In this blog post, let’s learn about the error message “3207 Value for DYNAMIC RESULT SETS must be zero.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3207 Value for DYNAMIC RESULT SETS must be zero.
Reason for the Error
In the CREATE PROCEDURE statement, you specified the optional DYNAMIC RESULT SETS clause with nonzero value.
Solution
Remove the clause or use the value zero, and then resubmit