In this blog post, let’s learn about the error message “30006 Both rowset and scalar host variables occur in the output list. Either all output host variables must be scalar or all output host variables must be rowsets.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
30006 Both rowset and scalar host variables occur in the output list. Either all output host variables must be scalar or all output host variables must be rowsets.
Reason for the Error
Stated in the message.
Solution
Refine your SELECT statement and resubmit
