SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual—523730-004
20-5
SQLSTATE Values
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.
0153D 1121 Attempting to perform a partition add, move, or drop on table
name. Partition operations are not allowed on tables with
vertical partitions, entry sequenced operations, and SYSKEY-
only partitioned tables.
0153E 1122 The number of specified partition key values (name) for object
name exceeds the number of key columns used, num.
0153F 1123 Unable to process the partition key values (name) for object
name. Please verify that the correct key value data types were
specified.
Table 20-1. SQLSTATE Values (page 4 of 85)
SQLSTATE SQLCODE Error Text