This table maintains a catalog of report bundle definitions.
Table 1. Report bundle definition table (ARSDFBDT)
| Column Name |
Data Type |
Description |
| BDT_RECIPIENT |
VARCHAR(60) |
Recipient name |
| BDT_DIST_NAME |
VARCHAR(60) |
Distribution name |
| BDT_SEQUENCE |
INTEGER |
Sequence number |
| BDT_REPORTID |
VARCHAR(60) |
Report ID |
| BDT_STATUS |
CHAR(1) |
Status; A=Active, I= Inactive |
| BDT_REPORTBUILD |
CHAR(1) |
Report build; F=Full Report, Q=Query specified |
| BDT_JNAME |
VARCHAR(8) |
Job name |
| BDT_FORMDEF |
VARCHAR(8) |
Form definition name |
| BDT_PAGEDEF |
VARCHAR(8) |
Page definition name |
| BDT_DEST |
VARCHAR(19) |
Destination |
| BDT_FORMSID |
VARCHAR(8) |
Forms ID |
| BDT_CLASS |
CHAR(1) |
Class |
| BDT_WRITER |
VARCHAR(8) |
Writer name |
| BDT_OUTLIM |
INTEGER |
Output limit |
| BDT_FCB |
VARCHAR(4) |
FCB |
| BDT_UCS |
VARCHAR(4) |
UCS |
| BDT_WAIT_IGNORE |
CHAR(1) |
Wait/ignore indicator |
| BDT_BURST |
CHAR(1) |
Burst |
| BDT_COPYM |
VARCHAR(8) |
COPYM |
| BDT_FLASH |
VARCHAR(6) |
Flash |
| BDT_NCOPY |
INTEGER |
Number of copies |
| BDT_LOCATION |
CHAR(1) |
Location |
| BDT_CUSTVR |
VARCHAR(55) |
Customer variables |
| BDT_EXITINFO |
VARCHAR(400) |
Exit information |
| BDT_DATASET |
VARCHAR(254) |
GDG dataset base name |
| BDT_SQL |
CLOB |
SQL query select statement |
| BDT_UPD_USERID |
VARCHAR(128) |
Last user to update the report bundle |
| BDT_UPD_DATE |
BIGINT |
Date and time report bundle definition was last updated |
| BDT_UPD_DT |
TIMESTAMP |
Date and time report bundle definition was last updated (timestamp format) |
| BDT_TRANSFORM |
INTEGER |
Transform indicator and output data type |
| DB2_GENERATED_ROWI |
ROWID |
Value generated by Db2 |
Table 2. Indexes for report bundle definition
table (ARSDFBDT)
| Index name |
Columns in index |
Type of index |
| ARSDFBDT_IDX1 |
BDT_RECIPIENT, BDT_DIST_NAME, BDT_SEQUENCE |
Unique cluster index for Db2; Unique index for Oracle and SQL Server |
| ARSDFBDT_IDX2 |
BDT_DIST_NAME |
Unique index |
| ARSDFBDT_IDX3 |
BDT_REPORTID |
Unique index |
| ARSDFBDT_IDX4 |
BDT_JNAME |
Unique index |