-604   A DATA TYPE DEFINITION SPECIFIES AN INVALID LENGTH, PRECISION, OR SCALE ATTRIBUTE

Explanation

A data type definition in a CREATE or ALTER statement is incorrect in one of the following ways:

  • The data type definition contains an invalid length, precision, or scale attribute specification.
  • The specification of the data type might be incorrect or invalid.
  • The column definition in a view referenced in a CREATE TABLE LIKE view statement has an invalid length.

System action

The statement cannot be processed. The specified object was not created or altered.

Programmer response

Correct the statement syntax as follows, and resubmit the statement:

  • Correct the data type definition in the statement to have a valid length, precision, or scale attribute.
  • Ensure that the specified data types are valid for the CREATE or ALTER statement.
  • Correct the invalid length in the column definition of the view that is referenced in the CREATE TABLE LIKE statement.

SQLSTATE

42611