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
To Next Page