(A10) AS400 table master (ZAMTBF)
| Field Name | Key | Data Type | Description |
|---|---|---|---|
| TBLIB | K | CHAR(10) | AS400 library name |
| TBOBJ | K | CHAR(10) | AS400 file name |
| TBMBR | K | CHAR(10) | AS400 member name |
| TBFMT | CHAR(10) | Record format | |
| TBREPL | CHAR(1) | To be replicated | |
| TBJLIB | CHAR(10) | Journal library | |
| TBJNAM | CHAR(10) | Journal name | |
| TBFLDN | NUMBER(5,0) | Number of fields | |
| TBRLEN | NUMBER(5,0) | Record length | |
| TBTXT | CHAR(50) | AS400 file text | |
| TBDWFG | CHAR(1) | Download flag Refer to (490) Learn QMirror/DB table status | |
| TBPRTY | NUMBER(2,0) | Download priority | |
| TBLOB | CHAR(1) | Large object (LOB) processing Refer to (480) Large object (LOB) processing | |
| TBMAXR | NUMBER(10,0) | Total records | |
| TBDLTR | NUMBER(10,0) | Deleted records | |
| TBDSCH | NUMBER(4,0) | Download schedule code Refer to (430) Re-download AS400 table manually | |
| TBSQLW | TEXT | Selected download SQL WHERE clause Refer to (580) Selected download | |
| TBNDDT | NUMBER(8,0) | Next download date | |
| TBNDTM | NUMBER(6,0) | Next download time | |
| TBDWDT | NUMBER(8,0) | Last download date | |
| TBDWTM | NUMBER(6,0) | Last download time | |
| TBSTS | CHAR(1) | Table status E – Error occurred for this table | |
| TBVRFY | CHAR(1) | Verification flag | |
| TBLIAS | CHAR(1) | Override alternative field name configuration Y – Apply alternative field name N – Not apply alternative field name blank – By configuration setting | |
| TBVRDT | NUMBER(8,0) | Last verification date | |
| TBVRTM | NUMBER(6,0) | Last verification time | |
| TBRMRK | CHAR(128) | Remark |