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

SYSTABAMDATA

The systabamdata system catalog table stores the table-specific hashing parameters of tables that were created with a primary access method.

The systabamdata table has the following columns.

Table 1. SYSTABAMDATA table column descriptions
Column	Type	Explanation
tabid	INTEGER	Identifying code of the table
am_param	LVARCHAR(8192)	Access method parameter choices
am_space	VARCHAR(128)	Name of the storage space holding the data values

The am_param column stores configuration parameters that determine how a primary access method accesses a given table. Each configuration parameter in the am_param list has the format keyword=value or keyword.

The am_space column specifies the location of the table. It might be located in a cooked file, a different database, or an sbspace within the database server.

The tabid column is the primary key to the systables table. This column is indexed and must contain unique values.