![HP NonStop SQL/MX Messages Manual Download Page 656](http://html.mh-extra.com/html/hp/nonstop-sql-mx/nonstop-sql-mx_messages-manual_165150656.webp)
SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21- 4
SQLSTATE Values
0151E
1050
Cannot drop constraint used as a referenced object for a
foreign key.
0151F
1051
Insufficient privilege on
table name
.
0151G
1052
Trying to drop a constraint that does not belong to requested
table.
0151H
1053
Unique index
table name
could not be created because the
column(s) specified contain duplicate data.
0151I
1054
Index
table name
already exists.
0151J
1055
Table, view, or stored procedure
table name
already exists.
0151L
1057
The DAM volume specified (
name
) is not available or is not
audit protected.
0151M
1058
Lock
table name
already exists.
0151N
1059
Request failed. Dependent constraint
name
exists.
0151P
1061
Cannot drop metadata catalog
name
.
0151Q
1062
Cannot drop metadata schema
name
.
0151R
1063
Cannot drop metadata index
table name
.
0151S
1064
Cannot drop metadata view
table name
.
0151T
1065
Cannot create constraint
name
in metadata schema.
0151U
1066
Cannot create index
table name
in metadata schema.
0151X
1069
Unable to drop schema
name
.
0151Y
1070
Unable to create object
table name
(file error
num
).
0151Z
1071
Unable to access object
table name
(file error
num
).
01520
1072
Unique constraint
name
is disabled; cannot create foreign key
constraint
name
.
01521
1073
Only the super ID user can execute INITIALIZE SQL.
01523
1075
Catalog
name
contains at least one schema. The catalog must
be empty.
01525
1077
Metadata table
name
does not contain information for view
name
.
01526
1078
The format of the specified location name
name
is invalid.
01527
1079
Unable to prepare the statement.
01528
1080
Duplicate references to column
name
in the create request.
01529
1081
Loading of index
table name
failed unexpectedly.
0152A
1082
Validation for constraint
name
failed unexpectedly.
0152B
1083
Validation for constraint
name
failed; incompatible data exists
in table.
0152C
1084
Invalid default value for column
name
.
Table 21-1. SQLSTATE Values (page 3 of 84)
SQLSTATE
SQLCODE
Error Text
Summary of Contents for NonStop SQL/MX
Page 4: ......
Page 8: ...Contents HP NonStop SQL MX Messages Manual 640324 001 iv ...
Page 26: ...General Messages 0 through 999 HP NonStop SQL MX Messages Manual 640324 001 2 2 ...
Page 130: ...SQL MX MXCMP Messages 2000 through 2999 HP NonStop SQL MX Messages Manual 640324 001 4 34 ...
Page 242: ...Normalizer Messages 5000 through 5999 HP NonStop SQL MX Messages Manual 640324 001 7 2 ...
Page 246: ...Optimizer Messages 6000 through 6999 HP NonStop SQL MX Messages Manual 640324 001 8 4 ...
Page 248: ...Generator Messages 7000 through 7999 HP NonStop SQL MX Messages Manual 640324 001 9 2 ...
Page 614: ...Utility Messages 20000 through 23099 HP NonStop SQL MX Messages Manual 640324 001 18 138 ...
Page 752: ...Non SQLCODE Error Messages HP NonStop SQL MX Messages Manual 640324 001 A 14 MXGNAMES Utility ...