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-67
SQLSTATE Values
X013Z -1143 Validation for constraint name failed; incompatible data exists
in referencing base table name and referenced base table
name. To display the data violating the constraint, please use
the following DML statement: name
X0140 -1144 Expected a quoted string in first key clause for column name
on table name, value detected is (name).
X0141 -1145 The catalog name name is reserved for SQL/MX metadata.
X0142 -1146 Unable to alter object name because it is not a name.
X0143 -1147 System-generated column name of base table name cannot
appear in a unique or primary key constraint definition.
X0144 -1148 System-generated column name of base table name cannot
appear in a referential integrity constraint definition.
X0151 -1181 Unable to drop object name (file error num).
X0152 -1182 Cannot instantiate constraint name, conflicting lock exists.
X0153 -1183 Cannot instantiate module name, conflicting lock exists.
X0154 -1184 Insufficient privilege on name.
X0155 -1185 The location name is either invalid or missing.
X0157 -1187 The schema name name is reserved for SQL/MX metadata.
X0158 -1188 Unable to create referential integrity constraint name for table
name due to circular dependency: name.
X015A -1190 Cannot find SQL/MP system catalog name, error num.
X015B -1191 Cannot find SQL/MP system catalog name,
DEVICE_GETINFOBYLDEV error num.
X015C -1192 Cannot find SQL/MP system catalog name,
FILE_GETINFOBYNAME_ error num.
X015G -1196 Unable to find SQL/MP system catalog name, invalid SQL/MP
location name.
X015H -1197 Invalid SQL/MP object name name.
X0165 -1221 Unable to create SQL/MP alias on file name, Distribution
Service/Data Access Manager error num
X0166 -1222 Invalid file type type.
X0168 -1224 Invalid data type for routine param name.
X0169 -1225 Error on access to PROCS table. SQL/MX error integer.
X016A -1226 Error on access to PARAMS table. SQL/MX error integer.
X016F -1231 Unable to create user-defined routine routine-name.
X0200 -2000 Error messages for compiler main, IPC, and DEFAULTS table;
assertions for optimizer.
Table 20-1. SQLSTATE Values (page 66 of 85)
SQLSTATE SQLCODE Error Text