-060 INVALID specification-type SPECIFICATION : specification-value
Explanation
The specified value is invalid.
- specification-type
- The type of specification: LENGTH or SCALE.
- specification-value
- The value specified.
LENGTH or SCALE must be specified by an unsigned integer constant and the value must be in the range allowed by the data type.
In addition:
- For a CREATE INDEX statement, a length specified for VARCHAR must not be greater than 1000, and an integer specified with DECFLOAT must be 34.
- For CREATE TABLE, CREATE TYPE, ALTER TABLE ADD COLUMN, or ALTER TABLE ALTER COLUMN statements, the INLINE LENGTH attribute specified for a LOB type must not exceed 32680 for a CLOB or BLOB column, or 16340 for a DBCLOB column.
System action
The statement cannot be processed.
Programmer response
Correct the syntax, and reissue the statement.
SQLSTATE
42815
