Hitachi

Hitachi Advanced Database Messages


KFAA30798-E

Invalid usage of DEFAULT clause for aa....aa "bb....bb". (reason = "cc....cc") (M+J+O)

A DEFAULT clause specification is invalid. <SQLSTATE: 42I72>

aa....aa: Type of error
  • column: Column

bb....bb:

Column name

cc....cc: Cause of the error
  • the specified default option cannot be assigned to the data type of the specified string

    The specified default option cannot be assigned to the data type of the column for which the DEFAULT clause is specified.

  • a null value cannot be specified for a column having the NOT NULL constraint

    NULL is specified for a column for which NOT NULL constraint is defined.

  • the length of the specified default option is invalid

    The length of the default value is invalid.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Correct the specification of the DEFAULT clause.