This
table maintains a catalog of distributions.
Table 1. Distribution table (ARSDFDCT)
| Column Name |
Data Type |
Description |
| DCT_RECIPIENT |
VARCHAR(60) |
Recipient/list name for this distribution |
| DCT_DIST_NAME |
VARCHAR(60) |
Distribution name |
| DCT_DIST_METHOD |
VARCHAR(8) |
Distribution method |
| DCT_STATUS |
CHAR(1) |
Status |
| DCT_JNAME |
VARCHAR(8) |
Job name |
| DCT_FORMDEF |
VARCHAR(8) |
Form definition name |
| DCT_PAGEDEF |
VARCHAR(8) |
Page definition name |
| DCT_DEST |
VARCHAR(19) |
Destination |
| DCT_FORMSID |
VARCHAR(8) |
Forms ID name |
| DCT_CLASS |
CHAR(1) |
Class |
| DCT_WRITER |
VARCHAR(8) |
Writer name |
| DCT_OUTLIM |
INTEGER |
Output limit |
| DCT_FCB |
VARCHAR(4) |
FCB |
| DCT_UCS |
VARCHAR(4) |
UCS |
| DCT_ACCOUNT |
VARCHAR(60) |
Account information |
| DCT_CONT_WAIT |
CHAR(1) |
Continue/wait indicator |
| DCT_CONT_MAXTRIES |
INTEGER |
Maximum number of times to continue print
processing |
| DCT_MANIFEST |
CHAR(1) |
Manifest Indicator |
| DCT_RPT_BREAK |
CHAR(1) |
Report break indicator |
| DCT_LOCATION |
CHAR(1) |
Location |
| DCT_CUSTVR |
VARCHAR(55) |
Customer variables |
| DCT_EXITINFO |
VARCHAR(400) |
Exit program information |
| DCT_DATASET |
VARCHAR(254) |
GDG dataset base name |
| DCT_UPD_USERID |
VARCHAR(128) |
Last user to update the distribution |
| DCT_UPD_DATE |
BIGINT |
Date and time distribution definition was last updated |
| DCT_UPD_DT |
TIMESTAMP |
Date and time distribution definition was last updated (timestamp format) |
| DCT_TRANSFORM |
INTEGER |
Transform indicator and output data type |
Table 2. Indexes for distribution definition table
(ARSDFDCT)
| Index name |
Columns in index |
Type of index |
| ARSDFDCT_IDX1 |
DCT_RECIPIENT, DCT_DIST_NAME |
Unique cluster index for Db2; Unique index for Oracle and SQL Server |
| ARSDFDCT_IDX2 |
DCT_DIST_NAME |
Unique index |
| ARSDFDCT_IDX3 |
DCT_JNAME |
Index |