HPE NonStop SQL/MX Error – 30014 Host variable used to set input size of rowset is not of type short, int, or long.

In this blog post, let’s learn about the error message “30014 Host variable used to set input size of rowset is not of type short, int, or long.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

30014 Host variable used to set input size of rowset is not of type short, int, or long.

Reason for the Error

You specified a hostvar for the input size of the rowset that is not of type short, int, or long.

Solution

Correct the syntax and resubmit