HP NonStop SQL/MX, Messages Manual

Page: 659 / 752

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21- 7
SQLSTATE Values
0153Z 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:
text
01540 1144 Expected a quoted string in first key clause for column
name
on table
name
, value detected is (
num
).
01541 1145 The catalog name
name
is reserved for SQL/MX metadata.
01542 1146 Unable to alter object
name
because it is not a
name
.
01543 1147 System-generated column
name
of base table
name
cannot
appear in a unique or primary key constraint definition.
01544 1148 System-generated column
name
of base table
name
cannot
appear in a referential integrity constraint definition.
01551 1181 Unable to drop object
name
(file error
num
).
01552 1182 Cannot instantiate constraint
name
, conflicting lock exists.
01553 1183 Cannot instantiate module
name
, conflicting lock exists.
01554 1184 Insufficient privilege on
name
.
01555 1185 The location name is either invalid or missing.
01556 1186 Column
name
is of type
type
, incompatible with the default
value's type,
type
.
01557 1187 The schema name
name
is reserved for SQL/MX metadata.
01558 1188 Unable to create referential integrity constraint
name
for table
name
due to circular dependency:
name
.
0155A 1190 Cannot find SQL/MP system catalog
name
, error
num
.
0155B 1191 Cannot find SQL/MP system catalog
name
,
DEVICE_GETINFOBYLDEV error
num
.
0155C 1192 Cannot find SQL/MP system catalog
name
,
FILE_GETINFOBYNAME_ error
num
.
0155G 1196 Unable to find SQL/MP system catalog
name
, invalid SQL/MP
location name.
0155H 1197 Invalid SQL/MP object name
name
.
01565 1221 Unable to create SQL/MP alias on file
name
, Distribution
Service/Data Access Manager error
num
01566 1222 Invalid file type
name
.
01568 1224 Invalid data type for routine param
name
.
01569 1225 Error on access to PROCS table. SQL/MX error
integer
.
0156A 1226 Error on access to PARAMS table. SQL/MX error
integer
.
0156F 1231 Unable to create user-defined routine
string
.
Table 21-1. SQLSTATE Values (page 6 of 84)
SQLSTATE SQLCODE Error Text