logo  
Google
 

DB2 SQL-Error: -4708

SQLState: 56038

Short Description: TABLE CANNOT BE DEFINED AS SPECIFIED IN THE C A DECLARE GLOBAL TEMPORARY TABLE LIKE AS FULLSELECT WITH NO DATA T LIKE AS FULLSELECT C C A ALTER TABLE M C C S T P C C C F CREATE TABLE C C DSNSPRM COMCRITYES D AS SECURITY LABEL F CREATE DECLARE LIKE AS FULLSELECT D CREATE ALTER TABLE C C

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: v 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. v 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 FULLSELECTfullselect clauses are not supported in a Common Criteria environment. v 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.

 <-  BACK TO INDEX