Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: ReferenceThe HCL OneDB™ Guide to SQL: Reference contains the reference information for the system catalog tables, data types, and environment variables of the HCL OneDB™ dialect of the SQL language, as implemented in HCL OneDB™. These topics also include information about the stores_demo, sales_demo, and superstore_demo databases that are included with HCL OneDB™.
Data typesEvery column in a table in a database is assigned a data type. The data type precisely defines the kinds of values that you can store in that column.
Description of Data Types
IDSSECURITYLABEL data typeThe IDSSECURITYLABEL type stores a security label in a table that is protected by a label-based access control (LBAC) security policy.

IDSSECURITYLABEL data type

The IDSSECURITYLABEL type stores a security label in a table that is protected by a label-based access control (LBAC) security policy.

Only a user who holds the DBSECADM role can create, alter, or drop a column of this data type. IDSSECURITYLABEL is a built-in DISTINCT OF VARCHAR(128) data type, but because its use is restricted to databases that implement label-based access control, it is not classified as a character data type. A table that is protected by a security policy can have only one IDSSECURITYLABEL column. A table that is not associated with any label-based security policy cannot include an IDSSECURITYLABEL column. You cannot encrypt the security label in a column of type IDSSECURITYLABEL.

For a discussion of security policies, security components, security labels, and other concepts of label-based access control (LBAC), see the HCL OneDB™ Security Guide.