Manualshelf

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

ManualsBrandsHP ManualsServerHP NonStop G-Series
571572573574575576577578579580
SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual—523730-004
20-13
SQLSTATE Values
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.
0171H 3053 Duplicate PRIMARY KEY clauses in column definition name.
0171I 3054 The NOT DROPPABLE clause is allowed only in PRIMARY
KEY and NOT NULL constraint definitions.
0171J 3055 Duplicate DELETE rules specified.
0171K 3056 Duplicate UPDATE rules specified.
0171L 3057 Invalid size value in the ALLOCATE clause.
0171M 3058 The BLOCKSIZE value must be 4096.
0171N 3059 Invalid size value in the MAXSIZE clause.
0171O 3060 Invalid percentage value in the DSLACK clause.
0171P 3061 The format of the specified location name name is invalid.
0171Q 3062 Duplicate MAXSIZE clauses in the PARTITION clause.
Table 20-1. SQLSTATE Values (page 12 of 85)
SQLSTATE SQLCODE Error Text