SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual—523730-004
20-55
SQLSTATE Values
42000 -3112 The LIKE clause and PARTITION clause cannot coexist in the
same statement.
42000 -3113 Error in CONTROL statement: name
42000 -3115 Duplicate ISOLATION LEVEL clause specified.
42000 -3116 Duplicate transaction access mode clause specified.
42000 -3117 Duplicate DIAGNOSTICS SIZE specified.
42000 -3118 Identifier too long.
42000 -3122 The format of the system name part in the specified location
name name is invalid. Currently the system name part must be
\NSK or /E/NSK.
42000 -3123 The format of the file name part in the specified location name
name is invalid. The file name part must be eight characters
long and end with the digits 00.
42000 -3127 Invalid character in identifier name.
42000 -3128 name is a reserved word. It must be delimited by double-
quotes to be used as an identifier.
42000 -3129 Function name accepts exactly one operand.
42000 -3132 The HEADING for column name exceeds the maximum size of
128 characters.
42000 -3133 PERFORM is valid only in COBOL programs.
42000 -3134 Precision of time or timeStamp, num, cannot exceed 6.
42000 -3135 Precision of float, value, cannot exceed 54.
42000 -3136 Only LEFT, RIGHT, and FULL OUTER JOIN are valid in {oj ...}
42000 -3138 A key-sequenced table with range partitioning requires a
FIRST KEY clause.
42000 -3139 A range-partitioned index requires a FIRST KEY clause.
42000 -3142 INTO clause host variables are not allowed in a static cursor.
42000 -3143 BROWSE or READ UNCOMMITTED access is not allowed on
a table value constructor.
42000 -3145 Positioned UPDATE or DELETE is allowed only in embedded
SQL.
42000 -3147 In an IN predicate whose right operand is a value list, the left
operand must be scalar (degree of one).
42000 -3149 Duplicate WITH CONSTRAINTS phrases in LIKE clause in
CREATE TABLE statement.
42000 -3150 Duplicate WITH HEADING phrases in LIKE clause in CREATE
TABLE statement.
Table 20-1. SQLSTATE Values (page 54 of 85)
SQLSTATE SQLCODE Error Text