Viewing SQL/MX messages
SQL 1000
The message key is a sequential SQL/MX message number that is returned automatically by NonStop SQL/MX when an exception condition occurs. For example, this message might be displayed within your application development tool while you prepare an embedded SQL program:
*** ERROR[1000] A syntax error occurred.
This message number is the SQLCODE value (without the sign). In this manual, you will find this message information for ERROR[1000]:
1000 A syntax error occurred.
Cause
You specified a statement with incorrect syntax.
Effect
The SQL/MX statement fails.
Recovery
Correct the syntax and resubmit.
From MXCI, use the ERROR command to:
-
Look up a message by its SQLCODE.
-
Display information for a message, including its SQLCODE, the SQLSTATE values for the SQLCODE, and the message text.
For more information about the ERROR command and its cause, effect, and recovery details, see the SQL/MX Reference Manual.