(A90) SQL statement master (ZTBSQL)
| Field Name | Key | Data Type | Description |
|---|---|---|---|
| ZQNDX | K | NUMBER(9,0) | Record index |
| ZQBOA | CHAR(1) | C/B/A-before or after table creation A – Execute AFTER the table is downloaded B – Execute BEFORE the table starts downloading C – Execute BEFORE the table is created | |
| ZQKEY | TEXT | Binding table list, separates by semicolon | |
| ZQSEQ | NUMBER(9,0) | Sequence of execution 99998 – Index buildup from AS400 physical file 99999 – Indexes buildup from AS400 logical files | |
| ZQSQL | TEXT | SQL statement | |
| ZQSTS | CHAR(1) | Status of execution A – Newly added by selection E – Failed to execute SQL statement in ZQSQL X – Omitted Z – Success to execute SQL statement in ZQSQL | |
| ZQPDT | NUMBER(8,0) | Execution date | |
| ZQPTM | NUMBER(6,0) | Execution time |