This table maintains a catalog of cabinet definitions.
Table 1. Cabinet table (ARSCAB)
Column Name |
Data Type |
Description |
name |
VARCHAR(60) |
Cabinet name |
description |
VARCHAR(120) |
Cabinet description |
cid |
INTEGER |
Cabinet identifier |
upd_userid |
VARCHAR(128) |
Userid of last user to update the cabinet |
upd_date |
BIGINT (Db2®, SQL Server), INT (Oracle) |
Date and time cabinet was last
updated (in old style) |
upd_dt |
TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) |
Date and time cabinet was last
updated |
Table 2. Indexes for cabinet table (ARSCAB)
Index name |
Columns in index |
Type of index |
arscab_name_idx |
name |
Unique index |
arscab_cid_idx |
cid |
Unique cluster index for Db2; Unique index for Oracle and SQL
Server |