SQL Environment Files
Various Reality files are defined on an account to enable it to be used as an SQL catalog. Some of these (for example, SQLINFO and SQLTYPES) are Q-pointers to files in the SYSFILES account; while others form the SQL catalog and are specific to the account in which the catalog resides; these include:
SQLTABLES Contains one item for each SQL table that is accessible from the account.
SQLCOLUMNSContains a column definition item for each column in each table defined in SQLTABLES
SQLINDEXESContains an index definition item for each index associated with the tables defined in SQLTABLES
SQLPROCS Contains definitions for SQL stored procedures.
None of these files should be edited directly. To ensure conformity with the Reality SQL server, modify the catalog either with SQL statements or using the SQLM utility.
Caution
The information in this topic is provided for support purposes only, and is subject to change without notice.