SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
22-2
SQLSTATE Values
SQLSTATE Values
For information about equivalent SQLCODE and SQLSTATE values for key messages
returned by NonStop SQL/MX and NonStop SQL/MP, see the section “Error Codes” in
the SQL/MX Comparison Guide for SQL/MP Users.
Table 22-1 is a list of returned SQLSTATE values ordered by SQLSTATE. SQLSTATE
values are provided for both warning messages (positive SQLCODE numbers) and
error messages (negative SQLCODE numbers).
Table 22-1. SQLSTATE Values (page 1 of 84)
SQLSTATE SQLCODE Error Text
00000 0 Successful completion
01001 8106 The last row fetched by this cursor was updated or deleted
between the FETCH and UPDATE/DELETE...WHERE
CURRENT... of statements.
01004 8402 A string overflow occurred during the evaluation of a character
expression.
01006 1015 Some of the specified privileges could not be revoked.
01007 1012 No privileges were granted. You lack grant option on the
specified privileges.
01007 1013 Not all privileges were granted. You lack grant option on some
of the specified privileges.
01500 1000 A syntax error occurred.
01501 1001 An internal error occurred in module name on line num.
DETAILS(details).
01502 1002 Catalog catalog does not exist, or has not been registered
on node node
01503 1003 Schema schema does not exist.
01504 1004 Table, view, or stored procedure object-name does not
exist or object type is invalid for the current operation.
01505 1005 Constraint constraint-name does not exist.
01506 1006 Index index-name does not exist.
01508 1008 User name user-name does not exist.
01509 1009 Column column-name does not exist in the specified table.
0150A 1010 The statement just specified is currently not supported.
0150E 1014 Privileges were not revoked. Dependent privilege descriptors
still exist.
0150G 1016 Redundant references to column column-name were
specified in the constraint or trigger definition.
0150H 1017 You are not authorized to perform this operation.
0150J 1019 No valid primary partition for table name could be found.