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.
SYSCHECKUDRDEP

SYSCHECKUDRDEP

The syscheckudrdep system catalog table describes each check constraint that is referenced by a user-defined routine (UDR) in the database. The syscheckudrdep table has the following columns.

Table 1. SYSCHECKUDRDEP table column descriptions
Column	Type	Explanation
udr_id	INTEGER	Unique code identifying the UDR
constraint_id	INTEGER	Unique code identifying the check constraint

Each check constraint described in the syscheckudrdep table also has its own row in the sysconstraints system catalog table, where the constrid column has the same value as the constraint_id column of syscheckudrdep.

A composite index on the udr_id and constraint_id columns requires that combinations of these values be unique.