![HP NonStop SQL/MX Messages Manual Download Page 715](http://html.mh-extra.com/html/hp/nonstop-sql-mx/nonstop-sql-mx_messages-manual_165150715.webp)
SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -63
SQLSTATE Values
X010L
-1021
SQL is already initialized on system
name
.
X010M
-1022
Schema
name
already exists.
X010N
-1023
Only the super ID user can name an authorization ID other
than the current user name.
X010O
-1024
Distribution Service/Data Access Manager error
num
occurred
in module
name
on line
num
. DETAILS(
text
).
X010P
-1025
Request failed. One or more dependent objects exist.
X010Q
-1026
Only the schema owner or the super ID user can drop a
schema.
X010R
-1027
The definition schema
name
is dropped when its catalog is
dropped.
X010S
-1028
Schema
name
contains at least one object. The schema must
be empty.
X010T
-1029
Unable to create object
name
.
X010U
-1030
Unable to access object
name
(file error
num
).
X010V
-1031
Unable to drop object
name
.
X010Y
-1034
Unable to initialize SQL.
X010Z
-1035
Catalog
name
already exists.
X0110
-1036
Only the super ID can execute DROP SQL.
X0111
-1037
SQL is not installed on system
name
.
X0112
-1038
All catalogs have not been dropped from the system.
X0113
-1039
Unable to drop SQL.
X0114
-1040
Cannot alter metadata table.
X0115
-1041
The primary key has already been defined.
X0116
-1042
All PRIMARY KEY or UNIQUE constraint columns must be
NOT NULL.
X0118
-1044
Unable to create constraint
name
. The referenced table does
not contain a unique constraint.
X0119
-1045
The unique constraint cannot be used because it is deferrable.
X011A
-1046
Referenced and referencing column lists do not match for
constraint
name
.
X011B
-1047
Unable to drop view
name
due to view being used by other
objects.
X011D
-1049
Attempting to drop a NOT DROPPABLE constraint.
X011E
-1050
Cannot drop constraint used as a referenced object for a
foreign key.
X011F
-1051
Insufficient privilege on
name
.
Table 21-1. SQLSTATE Values (page 62 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 ...