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-18
SQLSTATE Values
0174V 3175 Dynamic SQL statements are not allowed in compound
statements.
0174W 3176 Subqueries are not allowed in the IF Condition.
0174X 3177 Character set name requires an even number of characters in
the length declaration of the data type.
0174Y 3178 One or more of the following external (host-language) data
types incorrectly appears within the SQL query or operation:
name.
0174Z 3179 Collation name is not defined on the character set name.
01750 3180 STREAM statements are not allowed in compound
statements.
01751 3181 Invalid logical name, a three part logical name is required.
01752 3182 Extra semicolon(;) in a compound statement.
01757 3187 Not supported: SET STREAM TIMEOUT per a specific
stream.
01759 3189 Cannot set lock timeout on a view.
0175L 3201 EXTERNAL PATH clause is required.
0175M 3202 PARAMETER STYLE clause is required.
0175N 3203 LANGUAGE clause is required.
0175O 3204 EXTERNAL NAME clause is badly formed.
0175P 3205 EXTERNAL NAME clause is required.
0175Q 3206 The name for an object of this type must be fully qualified, or
set NAMETYPE ANSI.
0175R 3207 Value for DYNAMIC RESULT SETS must be zero.
0175S 3208 UNSIGNED numeric is not allowed for routine parameter.
01800 4000 Internal error in the query binder.
01801 4001 Column name is not found. Tables in scope: name. Default
schema: name.
01802 4002 Column name is not found. Table name not exposed. Tables in
scope: name. Default schema: name.
01803 4003 Column name is not a column in table name, or, after a
NATURAL JOIN or JOIN USING, is no longer allowed to be
specified with a table correlation name.
01804 4004 Column name name is ambiguous. Tables in scope: name.
Default schema: name.
01805 4005 Column reference name must be a grouping column or be
specified within an aggregate.
Table 20-1. SQLSTATE Values (page 17 of 85)
SQLSTATE SQLCODE Error Text