SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
22-17
SQLSTATE Values
0173V 3139 A range-partitioned index requires a FIRST KEY clause.
0173W 3140 The isolation level cannot be READ UNCOMMITTED for an
INSERT, UPDATE, DELETE, or DDL statement.
0173X 3141 The transaction access mode cannot be READ ONLY for an
INSERT, UPDATE, DELETE, or DDL statement.
0173Y 3142 INTO clause host variables are not allowed in a static cursor.
0173Z 3143 BROWSE or READ UNCOMMITTED access is not allowed on
a table value constructor.
01741 3145 Positioned UPDATE or DELETE is allowed only in embedded
SQL.
01743 3147 In an IN predicate whose right operand is a value list, the left
operand must be scalar (degree of one).
01744 3148 Environment variable name is being ignored because this
version of the code is Release, not Debug. Actual query
results will likely not match expected results.
01745 3149 Duplicate WITH CONSTRAINTS phrases in LIKE clause in
CREATE TABLE statement.
01746 3150 Duplicate WITH HEADING phrases in LIKE clause in CREATE
TABLE statement.
01747 3151 Duplicate WITH HORIZONTAL PARTITIONS phrases in LIKE
clause in CREATE TABLE statement.
01749 3153 The FIRST KEY clause is not allowed with hash partitioning.
0174B 3155 The POPULATE and NO POPULATE clauses cannot coexist
in the same CREATE INDEX statement.
0174D 3157 Catalog name is required.
0174E 3158 Invalid DATETIME name.
0174F 3159 If you intended name to be a character set specifier for a
character string literal, you must remove the spaces in front of
the single quote delimiter.
0174G 3160 name was declared more than once in the procedure
parameter list.
0174H 3161 name was not declared in the procedure parameter list.
0174I 3162 Procedure parameter name was not used.
0174J 3163 Host variable name appears more than once in the INTO list.
Execution results will be undefined.
0174K 3164 Data type mismatch between output host variable and
selected value.
0174L 3165 Min or max precision or exponent value exceeded, num.
0174M 3166 Min or max value for float or double value exceeded, num.
Table 22-1. SQLSTATE Values (page 16 of 84)
SQLSTATE SQLCODE Error Text