This section contains a description of each Content Manager OnDemand system table, including column names and data types. This section also contains a description of the application group data tables (also known as dynamic tables).
The system tables are created when the Content Manager OnDemand database is created by using the ARSDB program. The system tables are updated during normal operation in response to dynamic SQL statements.
Some column names differ between DB2, Oracle, and SQL Server
Some of the column names in the system control tables are reserved names in Oracle or SQL Server. Therefore, these column names differ between DB2, Oracle, and SQL Server. The following table describes the correspondence between the column names in DB2, Oracle, and SQL Server.
| Column name in system control table | Column name in Oracle | Column name in SQL Server |
|---|---|---|
| UID | USER_UId | UID |
| START | START_DATE | START |
| STOP | STOP_DATE | STOP |
| RESOURCE | RES_ID | RESOURCE |
| RID (For system i, the column name is \"RID\". ) | RID | RID |
| HOLD (For System i, the column name is HOLD_VAL.) | HOLD | HOLD |
| EXTERNAL | EXTERNAL | [EXTERNAL] |
