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.
SYSEXTDFILESThe sysextdfiles system catalog table contains identifying codes and the paths of external tables.

SYSEXTDFILES

The sysextdfiles system catalog table contains identifying codes and the paths of external tables.

For each external table, at least one row exists in the sysextdfiles system catalog table, which has the following columns.


Column	Type	Explanation
tabid	INTEGER	Unique identifying code of an external table
dfentry	CHAR(469)	Absolute source or target file path
blobdir	CHAR(344)	Absolute or relative directory name
clobdir	CHAR(344)	Absolute or relative directory name

You can use DBSCHEMA to write out the description of the external tables. To query these system catalog tables about an external table, use the tabid as stored in systables with tabtype = ‘E'.

An index on the tabid column allows duplicate values.