-4738   TABLE table-name CANNOT BE DEFINED AS SPECIFIED IN THE statement STATEMENT IN A COMMON CRITERIA ENVIRONMENT

Explanation

A CREATE, DECLARE, or ALTER statement attempted to define a new table or change an existing table in a Common Criteria environment, but the specification is not valid for one of the following reasons:
  • A CREATE TABLE statement included an explicit list of column definitions, but did not include a security label column. In a Common Criteria environment each table must be defined with a security label column.
  • A CREATE TABLE statement included a LIKE clause or AS FULLSELECT clause with the WITH NO DATA clause, to define a new base table. The LIKE clause and AS FULLSELECT fullselect clauses are not supported in a Common Criteria environment.
  • A CREATE TABLE statement included an AS fullselect clause to define a materialized query table, and the WITH NO DATA clause was not specified. Materialized query tables are not supported in a Common Criteria environment.
  • A DECLARE GLOBAL TEMPORARY TABLE statement included a LIKE clause, or AS FULLSELECT clause with the WITH NO DATA clause to define a new temporary table. The LIKE clause and AS FULLSELECT clauses are not supported in a Common Criteria environment.
  • An ALTER TABLE statement attempted to change a table to a materialized query table. Materialized query tables are not supported in a Common Criteria environment.

System action

The statement cannot be processed.

Programmer response

Change the statement so that it is valid in a Common Criteria environment.
  • For a CREATE TABLE statement that includes a lit of column definitions, if the statement is issued in a Common Criteria environment (DSN6SPRM COMCRIT=YES), then every table created must have a security label. Designate a column AS SECURITY LABEL or change the subsystem parameter.
  • For a CREATE or DECLARE statement that includes a LIKE or AS FULLSELECT clause, remove the clause and explicitly specify the attributes of the table that is being defined.
  • Do not issue a CREATE or ALTER TABLE statement that attempts to define a materialized query table in a Common Criteria environment.

SQLSTATE

56038