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

SYSERRORS

The syserrors system catalog table stores information about error, warning, and informational messages returned by DataBlade® modules and user-defined routines using the mi_db_error_raise( ) DataBlade API function.

For a description of an error message, use the finderr utility.

The syserrors table has the following columns.


Column	Type	Explanation
sqlstate	CHAR(5)	SQLSTATE value associated with the error.
locale	CHAR(36)	The locale with which this version of the message is associated (for example, en_us.8859-1)
level	SMALLINT	Reserved for future use
seqno	SMALLINT	Reserved for future use
message	VARCHAR(255)	Message text

To create a new message, insert a row directly into the syserrors table. By default, all users can view this table, but only users with the DBA privilege can modify it.

A composite index on the sqlstate, locale, level, and seqno columns allows only unique values.