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-5
SQLSTATE Values
0152D 1085 The calculated key length is greater than 255 bytes.
0152E 1086 Lock table name does not exist.
0152F 1087 Lock cannot be granted, conflicting operation is in progress.
0152G 1088 Cannot instantiate object table name, conflicting lock exists.
0152I 1090 Self-referencing constraints are currently not supported.
0152M 1094 Unable to drop object table name because it is not a name.
0152N 1095 The partition by column name should also be part of the
clustering/storage key.
0152Q 1098 Duplicate partition key (name) specified for object name.
0152R 1099 Column num is unnamed. You must specify an AS clause for
that column expression, or name all the columns by specifying
a view column list.
0152S 1100 Unable to select table.schema.name
0152T 1101 Unable to update table.schema.name
0152U 1102 Unable to insert rows into table.schema.name
0152V 1103 Unable to delete rows from table.schema.name
0152W 1104 Default value string too long for column name.
0152X 1105 CREATE TABLE LIKE statement cannot contain both
HORIZONTAL PARTITIONS and STORE BY clauses.
0152Y 1106 The specified partition name of object name does not exist.
01530 1108 The number of columns specified in the view column list, num,
does not match the degree of the query expression, num.
01531 1109 The WITH CHECK OPTION clause appears in the definition of
view table name, but the view is not updateable.
01533 1111 Error starting transaction.table name name name
01536 1114 Unable to create catalog name metadata tables on name.
01537 1115 Unable to create label for name (file error num) text.
01538 1116 The current partitioning scheme requires a user-specified
primary key on object name.
01539 1117 Cannot drop the only partition of the table. There must be at
least two partitions available to perform the drop.
0153A 1118 Cannot create object name in metadata schema.
0153B 1119 Cannot drop metadata object name.
0153C 1120 Attempting to change the audit flags for a table in an
unsupported way.
Table 22-1. SQLSTATE Values (page 4 of 84)
SQLSTATE SQLCODE Error Text