HPE NonStop SQL/MX Error – 13085 is not declared inside the SQL declare section

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

Error Message

13085 is not declared inside the SQL declare section

Reason for the Error

The variables to hold either SQLCODE or SQLSTATE or both were not declared in the SQL declare section of the embedded SQL application.

Solution

Declare variables to hold either SQLCODE or SQLSTATE or both, in the SQL declare section and preprocess the application