This table is used during ARSLOAD processing.
Table 1. Load work table (ARSLOADWORK)
| Column Name |
Data Type |
Description |
| agid |
INTEGER |
Application group identifier |
| aid |
INTEGER |
Application identifier |
| loadid |
VARCHAR(128) |
Load identifier |
| load_file |
VARCHAR(1000) |
Load input file name |
| start_dt |
TIMESTAMP (Db2®, Oracle),
DATETIME2(6) (SQL Server) |
Start date for the load |
| update_dt |
TIMESTAMP (Db2, Oracle),
DATETIME2(6) (SQL Server) |
Update date if the load date changes |
Table 2. Indexes for load work table (ARSLOADWORK)
| Index name |
Columns in index |
Type of index |
| arsloadwork_idx |
agid, aid, load_file |
Unique index |
| arsloadwork_loadid_idx |
agid, aid, loadid |
Unique cluster index for Db2; Unique index for Oracle and SQL Server |