logo  
Google
 

DB2 SQL-Error: -20240

SQLState: 42963

Short Description: INVALID SPECIFICATION OF A SECURITY LABEL COLUMN REASON CODE

For a security label column the specification of an attribute in a CREATE TABLE, or ALTER TABLE, DECLARE GLOBAL TEMPORARY TABLE, or CREATE GLOBAL TEMPORARY TABLE statement may be invalid for one of the following reasons: 1 The underlying data type of the security label column is not supported. A security label column must be defined as CHAR(8) for single-byte data. 2 An edit procedure was specified for the table with a security label column. 3 A security label column must be defined as NOT NULL WITH DEFAULT. 4 A security label column cannot be defined for a created global temporary table. 5 The data type of a security label column cannot be altered. 6 A security label column cannot be defined for a table that is the source for a materialized query table. 7 A check constraint cannot specify a security label column.System action: The statement cannot be executed. Programmer response: Correct the syntax and resubmit the statement.

 <-  BACK TO INDEX