-20240   INVALID SPECIFICATION OF A SECURITY LABEL COLUMN table-name.column-name REASON CODE 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 might be invalid.

table-name

The name of the table.

column-name

The name of the column.

reason-code

The reason for the message or SQL code, indicated by one of the following values:

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 that is defined with row attribute sensitivity 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 DEFAULT cannot be altered.

5

A security label column cannot be defined for a created global temporary table.

6

The data type of a security label column cannot be altered.

7

A security label column cannot be defined for a table that is the source for a materialized query table.

8

A check constraint cannot specify a security label column.

9

A security label column cannot be defined for an accelerator-only table.