HPE NonStop SQL/MX Error – 13086 variable is not declared of type inside the declare section

In this blog post, let’s learn about the error message “13086 variable is not declared of type inside the declare section” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

13086 variable is not declared of type inside the declare section

Reason for the Error

The data type of a variable declared in the SQL declare section to hold either SQLCODE or SQLSTATE or both was not correct. The variable type to hold SQLCODE must be long and to hold SQLSTATE must be char[6].

Solution

Declare a long or char[6] variable to hold either SQLCODE or SQLSTATE in the declare section, and preprocess the application