SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual—640324-001
21-56
SQLSTATE Values
42000 -3150 Duplicate WITH HEADING phrases in LIKE clause in CREATE
TABLE statement.
42000 -3151 Duplicate WITH HORIZONTAL PARTITIONS phrases in LIKE
clause in CREATE TABLE statement.
42000 -3153 The FIRST KEY clause is not allowed with hash partitioning.
42000 -3155 The POPULATE and NO POPULATE clauses cannot coexist
in the same CREATE INDEX statement.
42000 -3157 Catalog name is required.
42000 -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.
42000 -3160 name was declared more than once in the procedure
parameter list.
42000 -3161 name was not declared in the procedure parameter list.
42000 -3164 Data type mismatch between output host variable and
selected value.
42000 -3165 Min or max precision or exponent value exceeded, num.
42000 -3166 Min or max value for float or double value exceeded, num.
42000 -3167 Duplicate [ NOT ] DROPPABLE clauses.
42000 -3168 The FOR ... ACCESS clause is not allowed in a CREATE
VIEW statement.
42000 -3171 Transaction statements are not allowed in compound
statements.
42000 -3172 EXIT is not allowed in a compound statement.
42000 -3173 UPDATE STATISTICS is not allowed in a compound
statement.
42000 -3174 DDL statements are not allowed in compound statements.
42000 -3175 Dynamic SQL statements are not allowed in compound
statements.
42000 -3176 Subqueries are not allowed in the IF Condition.
42000 -3177 Character set name requires an even number of characters in
the length declaration of the data type.
42000 -3178 One or more of the following external (host-language) data
types incorrectly appears within the SQL query or operation:
type.
42000 -3179 Collation name is not defined on the character set name.
42000 -3180 STREAM statements are not allowed in compound
statements.
Table 21-1. SQLSTATE Values (page 55 of 84)
SQLSTATE SQLCODE Error Text
To Next Page