![HP NonStop SQL/MX Messages Manual Download Page 717](http://html.mh-extra.com/html/hp/nonstop-sql-mx/nonstop-sql-mx_messages-manual_165150717.webp)
SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -65
SQLSTATE Values
X012F
-1087
Lock cannot be granted, conflicting operation is in progress.
X012G
-1088
Cannot instantiate object
name
, conflicting lock exists.
X012M
-1094
Unable to drop object
name
because it is not a
name
.
X012N
-1095
The partition by column
name
should also be part of the
clustering/storage key.
X012Q
-1098
Duplicate partition key (
name
) specified for object
name
.
X012R
-1099
Column
num
is unnamed. You must specify an AS clause for
that column expression, or name all the columns by specifying
a view column list.
X012S
-1100
Unable to select
name.schema.name
.
X012T
-1101
Unable to update
name.schema.name
.
X012U
-1102
Unable to insert rows into
name.schema.name
.
X012V
-1103
Unable to delete rows from
name.schema.name
.
X012W
-1104
Default value string too long for column
name
.
X012X
-1105
CREATE TABLE LIKE statement cannot contain both
HORIZONTAL PARTITIONS and STORE BY clauses.
X012Y
-1106
The specified partition
name
of object
name
does not exist.
X0130
-1108
The number of columns specified in the view column list,
num
,
does not match the degree of the query expression,
num
.
X0131
-1109
The WITH CHECK OPTION clause appears in the definition of
view name, but the view is not updateable.
X0136
-1114
Unable to create catalog
name
metadata tables on
name
.
X0137
-1115
Unable to create label for
name
(file error
num
)
name
.
X0138
-1116
The current partitioning scheme requires a user-specified
primary key on object
name
.
X0139
-1117
Cannot drop the only partition of the table. There must be at
least two partitions available to perform the drop.
X013A
-1118
Cannot create object
name
in metadata schema.
X013B
-1119
Cannot drop metadata object
name
.
X013E
-1122
The number of specified partition key values (
num
) for object
name
exceeds the number of key columns used,
num
.
X013G
-1124
Schema
name
is an unknown version.
X013H
-1125
API request version number mismatch.
X013J
-1127
The specified table
name
is not a base table. Please verify that
the correct table was specified.
X013K
-1128
Invalid API request. Details:
text
.
X013M
-1130
The column requires a default value.
Table 21-1. SQLSTATE Values (page 64 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 ...