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-65
SQLSTATE Values
X012F -1087 Lock cannot be granted, conflicting operation is in progress.
X012G -1088 Cannot instantiate object name, conflicting lock exists.
X012M -1094 Unable to drop object name because it is not a name.
X012N -1095 The partition by column name should also be part of the
clustering/storage key.
X012Q -1098 Duplicate partition key (name) specified for object name.
X012R -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.
X012S -1100 Unable to select name.schema.name.
X012T -1101 Unable to update name.schema.name.
X012U -1102 Unable to insert rows into name.schema.name.
X012V -1103 Unable to delete rows from name.schema.name.
X012W -1104 Default value string too long for column name.
X012X -1105 CREATE TABLE LIKE statement cannot contain both
HORIZONTAL PARTITIONS and STORE BY clauses.
X012Y -1106 The specified partition name of object name does not exist.
X0130 -1108 The number of columns specified in the view column list, num,
does not match the degree of the query expression, num.
X0131 -1109 The WITH CHECK OPTION clause appears in the definition of
view name, but the view is not updateable.
X0136 -1114 Unable to create catalog name metadata tables on name.
X0137 -1115 Unable to create label for name (file error num) name.
X0138 -1116 The current partitioning scheme requires a user-specified
primary key on object name.
X0139 -1117 Cannot drop the only partition of the table. There must be at
least two partitions available to perform the drop.
X013A -1118 Cannot create object name in metadata schema.
X013B -1119 Cannot drop metadata object name.
X013E -1122 The number of specified partition key values (num) for object
name exceeds the number of key columns used, num.
X013G -1124 Schema name is an unknown version.
X013H -1125 API request version number mismatch.
X013J -1127 The specified table name is not a base table. Please verify that
the correct table was specified.
X013K -1128 Invalid API request. Details: text.
X013M -1130 The column requires a default value.
Table 22-1. SQLSTATE Values (page 64 of 84)
SQLSTATE SQLCODE Error Text