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™.
System catalog tablesThe system catalog consists of tables and views that describe the structure of the database. Sometimes called the data dictionary, these table objects contain everything that the database knows about itself. Each system catalog table contains information about specific elements in the database. Each database has its own system catalog.
SYSSECLABELCOMPONENTELEMENTS

SYSSECLABELCOMPONENTELEMENTS

The sysseclabelcomponentelements system catalog table records the values of component elements of security labels. It has these columns.


Column	Type	Explanation
compid	INTEGER	Component ID
element	VARCHAR(32)	Element name
elementencoding	CHAR(8)	Encoded form of the element
parentelement	VARCHAR(32)	The name of the parent elements for tree components. The value is NULL for the following items: Set components Array components Root nodes of a tree component
alterversion	SMALLINT	The number of the alter operation when the element is added. This value is used by the dbexport and dbimport commands.