DSNH350I E csect-name column-name WAS IMPLICITLY OR EXPLICITLY REFERENCED IN A CONTEXT IN WHICH IT CANNOT BE USED

Explanation

The ALTER, CREATE, or DECLARE TEMPORARY TABLE statement is invalid for one of the following reasons:
DECFLOAT columns
A DECFLOAT column cannot be:
  • Specified as a column of a foreign key in a referential-constraint clause.
  • Specified as a column of a parent key in a REFERENCES clause.
  • Specified as a column of a partitioning key for range partitioning.
  • Defined in a table that has an EDITPROC.
  • The result data type of a key expression in an expression-based index must not be DECFLOAT or a distinct type based on the DECFLOAT data type. An intermediate result of a key expression for an index can be the DECFLOAT data type or a distinct type based on the DECFLOAT data type.
LOB columns
A LOB column cannot be:
  • Specified as a column of the primary key in a PRIMARY KEY clause.
  • Specified as a column of a UNIQUE KEY.
  • Specified as a column of a foreign key in a referential-constraint clause.
  • Specified as a column of a parent key in a REFERENCES clause.
  • Specified as a column of a partitioning key for range partitioning.
  • Defined in a temporary table (created global temporary table or declared global temporary table).
  • Defined in a table that has an EDITPROC.
  • Specified as a column of an index key
  • The result data type, including the intermediate result, of a key expression for an index (this includes distinct types that are based on a LOB).
  • The data type of a column in the result table of an as-result-table clause of a CREATE TABLE or DECLARE GLOBAL TEMPORARY TABLE statement.
  • Defined in a table that has an edit procedure that is defined with row attribute sensitivity.
security label columns
A security label column cannot be:
  • Specified as a column of a foreign key in a referential-constraint clause.
  • Specified as a column of a parent key in a REFERENCES clause.
  • Specified in a key expression for an index.

A security label column column-name exists in the result table of the as-result-table clause; however, it is not the only security label column in that result table. A table can be defined only with a single security label column.

XML columns
An XML column cannot be:
  • Specified as a column of the primary key in a PRIMARY KEY clause.
  • Specified as a column of a UNIQUE KEY.
  • Specified as a column of a foreign key in a referential-constraint clause.
  • Specified as a column of a parent key in a REFERENCES clause.
  • Specified as a column of a partitioning key for range partitioning.
  • Defined in a temporary table (created global temporary table or declared global temporary table).
  • Defined in a table that has an EDITPROC.
  • Specified as a column of an index key
  • The result data type, including the intermediate result, of a key expression for an index.
  • The data type of a column in the result table of an as-result-table clause of a CREATE TABLE or DECLARE GLOBAL TEMPORARY TABLE statement.
  • Defined in a table that has an edit procedure that is defined with row attribute sensitivity.
hidden columns
A hidden column cannot be specified in a key expression for an index.
ROWID columns
A ROWID column cannot be the data type of a column in the result table of an as-result-table clause of a CREATE TABLE or DECLARE GLOBAL TEMPORARY TABLE statement.

System action

The statement cannot be processed.

User response

Correct the syntax, and reissue the statement.

Severity

8 (error)