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-13
SQLSTATE Values
0170R 3027 name is not a valid simple name; it has more than one name
part.
0170S 3028 Specifying a privilege column list in the INSERT clause is not
yet supported.
0170T 3029 name is not yet supported in referential integrity constraint
definition.
0170U 3030 The PARALLEL EXECUTION clause is not yet supported.
0170V 3031 CASCADE drop behavior is not yet supported.
0170W 3032 The COLUMN clause in the ALTER TABLE statement is not
yet supported.
0170X 3033 The MOVE clause in the ALTER TABLE statement is not yet
supported.
0170Y 3034 The PARTITION clause in the ALTER TABLE statement is not
yet supported.
0170Z 3035 The RENAME clause in the ALTER TABLE statement is not
yet supported.
01710 3036 The SET CONSTRAINT clause in the ALTER TABLE
statement is not yet supported.
01711 3037 Precision of type data type cannot exceed 18.
01712 3038 PIC X types cannot have leading signs, or any signs at all.
01713 3039 PIC X types do not have any COMP representation.
01714 3040 Precision zero is invalid. Add a '9' to the PICTURE clause.
01715 3041 UNSIGNED is invalid for a numeric or decimal type with a
scale greater than 9.
01716 3042 UPSHIFT for a numeric type is invalid.
01717 3043 Precision greater than 18 for a COMP numeric type is invalid.
01718 3044 Invalid interval value.
01719 3045 Invalid date value.
0171A 3046 Invalid time value.
0171B 3047 Invalid timestamp timestamp.
0171C 3048 Dynamic parameters, such as name, are not allowed in a static
compilation.
0171D 3049 Host variables, such as name, are not allowed in a dynamic
compilation.
0171E 3050 The constraint must have the same catalog and schema as
the specified table.
0171F 3051 Duplicate HEADING clauses in column definition name.
0171G 3052 Duplicate NOT NULL clauses in column definition name.
Table 22-1. SQLSTATE Values (page 12 of 84)
SQLSTATE SQLCODE Error Text