>db2 "? sql548"


SQL0548N A check constraint or generated column that is defined with
"<check-condition-element>" is invalid.

Explanation:

A check constraint in the CREATE TABLE or CREATE NICKNAME, ALTER TABLE
or ALTER NICKNAME statement is invalid for one or more of the following
reasons:

* the constraint definition contains a subquery
* the constraint definition contains a column function
* the constraint definition contains a host variable
* the constraint definition contains a parameter marker
* the constraint definition contains a special register or a built-in
function that depends on the value of a special register
* the constraint definition contains a global variable
* the constraint definition contains a function that is not
deterministic
* the constraint definition contains a user defined function with
external action
* the constraint definition contains a user defined function with the
scratchpad option
* the definition contains a user defined function with the CONTAINS SQL
or READS SQL DATA option
* the definition contains a reference to a generated column which is
based on an expression
* the check constraint is part of a column definition, and its
check-condition contains a reference to a column name other than the
column being defined
* the generated column definition contains a reference to itself
* the constraint definition contains a dereference operation or a DEREF
function where the scoped reference argument is other than the object
identifier (OID) column.
* the constraint definition uses a TYPE predicate.
* the constraint definition includes a CAST specification with a SCOPE
clause.
* the constraint or generated column definition contains a text search
function.
* the constraint definition contains an XML column.
* the constraint definition contains an XMLQUERY or XMLEXISTS
expression.

The token within the text of the error message lists the invalid item.

The statement cannot be processed.

User response:

The user response is one of the following, depending on the cause of the
error:

* change the check constraint or generated column so that it does not
include the listed item.
* move the check constraint definition outside the column definition,
so that it becomes a table level constraint definition.