GENESIS Tables

Although appearing under the PUBLIC schema, GENESIS_TABLES is actually in a special class of objects in the database called system tables, not to be confused with the SYSTEM schema. These system tables are internal tables required by the AcuXDBC processor. When you execute SQL statements, the AcuXDBC processor constantly refers to these tables to complete the SQL command. These system tables are marked as System tables in the catalog, and they begin with GENESIS_. If you don't want to see these tables in tools such as Microsoft Query, uncheck the System Tables checkbox under the Options button of the Add Tables dialog box.

You cannot change or modify these system tables directly. The content of these tables is maintained by the AcuXDBC processor and is modified only as an effect of executing various SQL statements or the use of the AcuXDBC command-line tools and scripts, such as addfile. For example, issuing the following command not only results in AcuXDBC creating a new table, it also results in a new row being entered into the table GENESIS_TABLES.

CREATE TABLE MYTABLE(coll CHAR(10)); 

This effect can be seen in asql with the following command:

SQL (/? for help) ==> SELECT
SQL continued ======>      t_owner, t_name
SQL continued ======> FROM
SQL continued ======>      genesis_tables
SQL continued ======> WHERE
SQL continued ======>      t_name = 'MYTABLE';

 T_OWNER                        T_NAME
 ------------------------------ ------------------
 SYSTEM                         MYTABLE

SQL (/? for help) ==>

Note that the table name in the query is in upper case.

The system tables include the following:

Table Name Description
GENESIS_AUTHS Enables the setting of object-level authorizations on objects (for example, tables and views) by the GRANT SQL statement. These privileges are SELECT, INSERT, UPDATE, and DELETE
GENESIS_COLUMNS Provides the mapping between SQL tables/views and the columns that comprise them. These fields are equivalent to the COBOL fields that comprise a File Descriptor (FD)
GENESIS_CONDITIONS     Tracks the conditions used to modify the result set based on the values in certain columns
GENESIS_DEPENDS Keeps track of view dependencies
GENESIS_FORKEYS Defines foreign key relationships, but is not currently used.
GENESIS_INDEXES Provides the mapping between SQL indexes and the COBOL keys
GENESIS_TABLES Provides information about the tables and views that comprise a database. This contains all of the COBOL XFD files that you have loaded into the database, as well as system tables
GENESIS_USERS Enables a security method based on user ID and password
GENESIS_VIEWS Describes the SQL view definition
GENESIS_XCOLUMNS Provides the mapping between SQL indexes and the COBOL key segments