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.
SYSXASOURCETYPESThe sysxasourcetypes system catalog table stores XA data source types.

SYSXASOURCETYPES

The sysxasourcetypes system catalog table stores XA data source types.

The sysxasourcetypes table has the following columns.


Column	Type	Explanation
xa_source_typeid	SERIAL	A unique identifier for the source type
xa_source_owner	CHAR(32)	The user ID of the owner
xa_source_name	VARCHAR(128)	The name of the source type
xa_flags	INTEGER
xa_version	INTEGER
xa_open	INTEGER	UDR ID of xa_open_entry
xa_close	INTEGER	UDR ID of xa_close_entry
xa_start	INTEGER	UDR ID of xa_start entry
xa_end	INTEGER	UDR ID of xa_end_entry
xa_rollback	INTEGER	UDR ID of xa_rollback_entry
xa_prepare	INTEGER	UDR ID of xa_prepare_entry
xa_commit	INTEGER	UDR ID of xa_commit_entry
xa_recover	INTEGER	UDR ID of xa_recover_entry
xa_forget	INTEGER	UDR ID of xa_forget_entry
xa_complete	INTEGER	UDR ID of xa_complete_entry