This table maintains a catalog of report bundles that
are submitted for print processing.
Table 1. Print processor table (ARSDFPPT)
| Column Name |
Data Type |
Description |
| PPT_RECIPIENT |
VARCHAR(60) |
Recipient name |
| PPT_DIST_NAME |
VARCHAR(60) |
Distribution name |
| PPT_SEQUENCE |
INTEGER(4) |
Sequence number |
| PPT_REPORTID |
VARCHAR(60) |
Report ID |
| PPT_LISTID |
VARCHAR(60) |
List ID |
| PPT_APPLGRP_NAME |
VARCHAR(60) |
Application group name |
| PPT_APPL_NAME |
VARCHAR(60) |
Application name |
| PPT_AGID |
INTEGER(4) |
Application Group ID |
| PPT_AID |
INTEGER(4) |
Application ID |
| PPT_LOADID |
VARCHAR(128) |
Load ID |
| PPT_LOAD_SIZE |
BIGINT(8) |
Number of Bytes Loaded |
| PPT_RID |
INTEGER(4) |
Resource ID |
| PPT_RES_SIZE |
DB2 TIMESTAMP |
Resource size |
| PPT_LOCATION |
CHAR(1) |
Location |
| PPT_FILE_DIR |
VARCHAR(254) |
File directory |
| PPT_EMAIL |
VARCHAR(254) |
E-mail address |
| PPT_TRANSFORM |
INTEGER(4) |
Transform indicator; 0=None, 1=UTF-8, 3=PDF |
| PPT_CREATE_DT |
TIMESTAMP |
Timestamp when the report bundle request
was created |
| PPT_PROCESS_DT |
TIMESTAMP |
Timestamp when the report bundle was processed |
| PPT_COMPLETE_DT |
TIMESTAMP |
Timestamp when the report bundle completed |
| PPT_STATUS |
INTEGER(4) |
Status |
| PPT_LINE_COUNTER |
BIGINT(8) |
Line counter |
| PPT_PAGE_COUNTER |
INTEGER(4) |
Page counter |
| PPT_EXCPT_MSG_NUM |
INTEGER(4) |
Exception message number |
| PPT_REPRINT |
INTEGER(4) |
Reprint indicator |
| PPT_JNAME |
VARCHAR(8) |
Job name |
| PPT_FORMDEF |
VARCHAR(8) |
Form definition name |
| PPT_PAGEDEF |
VARCHAR(8) |
Page definition name |
| PPT_FORMSID |
VARCHAR(8) |
Forms ID |
| PPT_DEST |
VARCHAR(19) |
Destination |
| PPT_CLASS |
CHAR(1) |
Class |
| PPT_WRITER |
VARCHAR(8) |
Writer name |
| PPT_FCB |
VARCHAR(4) |
FCB |
| PPT_UCS |
VARCHAR(4) |
UCS |
| PPT_ACCOUNT |
VARCHAR(60) |
Account |
| PPT_BURST |
CHAR(1) |
Burst |
| PPT_COPYM |
VARCHAR(8) |
COPYM |
| PPT_FLASH |
VARCHAR(6) |
Flash |
| PPT_CUSTVR |
VARCHAR(55) |
Customer variables |
| PPT_EXITINFO |
VARCHAR(400) |
Exit information |
| PPT_OUTLIM |
INTEGER(4) |
Output limit |
| PPT_NCOPY |
INTEGER(4) |
Number of copies |
| PPT_STARTPAGE |
BIGINT(8) |
First page of range of pages to print |
| PPT_ENDPAGE |
BIGINT(8) |
Last page of range of pages to print |
| PPT_SQL |
CLOB(4) |
SQL query select statement |
Table 2. Indexes for print processor
table (ARSDFPPT)
| Index name |
Columns in index |
Type of index |
| ARSDFPPT_IDX1 |
PPT_RECIPIENT, PPT_DIST_NAME, PPT_SEQUENCE |
Unique cluster index for DB2; Unique index for Oracle and SQL Server |