This table is a catalog of holds.
Table 1. ARSHOLD table
| Column Name |
Data Type |
Description |
| name |
VARCHAR(60) |
Name of hold |
| description |
VARCHAR(120) |
Description of hold |
| hid |
INTEGER |
Hold identifier |
| upd_userid |
VARCHAR(128) |
User ID that created the hold |
| upd_date |
BIGINT (Db2®, SQL Server), INT (Oracle) |
Timestamp when the hold was created (in
old style) |
| upd_dt |
TIMESTAMP (Db2, Oracle), DATETIME2(6) (SQL Server) |
Timestamp when the hold was
created |
Table 2. Indexes for ARSHOLD table
| Index name |
Columns in index |
Type of index |
| arshold_name_idx |
name |
Unique index |
| arshold_hid_idx |
hid |
Unique cluster index for Db2; Unique index for Oracle and SQL
Server |