HPE NonStop SQL/MX Error – 30013 Host variable used to set input size of rowset has zero or negative value.

In this blog post, let’s learn about the error message “30013 Host variable used to set input size of rowset has zero or negative value.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

30013 Host variable used to set input size of rowset has zero or negative value.

Reason for the Error

You specified a hostvar with a zero or negative value for the input size of the rowset.

Solution

Correct the syntax and resubmit