Neoview Messages Manual (R2.2)

Table 22-7 SQLSTATE Values Beginning 42000 (continued)
Error TextSQLCODESQLSTATE
In a dynamic cursor declaration both the cursor and the statement must be named in
the same way: both must be literals or both must be string host variable expressions.
-300642000
In an ALLOCATE CURSOR statement both the cursor and the statement must be
named using string host variables.
-300742000
Precision of name UNSIGNED data type, value, cannot exceed 9.
-300842000
name is not a valid qualified name; it has more than 3 name parts.
-301142000
COUNT is the only aggregate function that accepts (*) as an operand.-301242000
Subtraction is the only operation allowed in the parenthesized expression preceding
an interval qualifier.
-301342000
Precision of numeric, value, cannot exceed 18.
-301442000
Scale value cannot exceed precision value.
-301542000
Precision of decimal, value, cannot exceed 18.
-301642000
Expected an unsigned integer, not value.
-301742000
Expected an unsigned smallint, not value.
-301842000
Expected an unsigned number within the parentheses, not value.
-301942000
Expected an unsigned number as the first operand within the parentheses, not value.
-302042000
Expected an unsigned number as the second operand within the parentheses, not
value.
-302142000
The format of the subvolume name part in the specified location name name is invalid.
The subvolume name part must be eight characters long and begin with the letters
ZSD.
-302542000
A comma must be used to separate file attributes.-302642000
name is not a valid simple name; it has more than one name part.
-302742000
Precision of type data type cannot exceed 18.
-303742000
PIC X types cannot have leading signs, or any signs at all.-303842000
PIC X types do not have any COMP representation.-303942000
Precision zero is invalid. Add a '9' to the PICTURE clause.-304042000
UNSIGNED is invalid for a numeric or decimal type with a scale greater than 9.-304142000
UPSHIFT for a numeric type is invalid.-304242000
Precision greater than 18 for a COMP numeric type is invalid.-304342000
Dynamic parameters, such as name, are not allowed in a static compilation.
-304842000
Host variables, such as name, are not allowed in a dynamic compilation.
-304942000
The constraint must have the same catalog and schema as the specified table.-305042000
Duplicate HEADING clauses in column definition name.
-305142000
Duplicate NOT NULL clauses in column definition name.
-305242000
Duplicate PRIMARY KEY clauses in column definition name.
-305342000
The NOT DROPPABLE clause is allowed only in PRIMARY KEY and NOT NULL
constraint definitions.
-305442000
Duplicate DELETE rules specified.-305542000
436 SQLSTATE Values Returned by the Neoview Database