logo  
Google
 

DB2 SQL-Error: -548

SQLState: 42621

Short Description: A CHECK CONSTRAINT THAT IS DEFINED WITH IS INVALID C E SQL T T ROWID T LOB S T F ALTER TABLE T F CREATE TABLE P C

A check constraint in the CREATE TABLE or ALTER TABLE statement is invalid for one or more of the following reasons: v The constraint definition refers to a column that has a field procedure. v The constraint definition refers to a column with a data type that is lower in the hierarchy of numeric data types than the data type of any other operand. The hierarchy is as follows: small integer < large integer < decimal < single precision float < double precision float v The constraint definition refers to a column with a numeric data type that is not the same numeric data type as that of the other column operands.

 <-  BACK TO INDEX