The log tables contain information that is written to the log tables during processing. The log database includes the transaction log table, the trace file, the run ID table, and an error table. The -sl runtime switch indicates that an ODBC log database is being used.
The AFLD field in the log table (TRLOG) should be an AUTOINCREMENT
field. If it is not, a provision must be made to assign a unique
numeric value to this field every time a record is inserted into
this table.
Number |
Field name |
Field type |
Field precision |
|---|---|---|---|
1 |
AFLD |
AUTOINCREMENT |
10 |
2 |
RUN_ID |
SQL_BIG_INT |
9 |
3 |
TYP |
SQL_VARCHAR |
1 |
4 |
RUN_DATE |
SQL_TIMESTAMP |
14 |
5 |
ACKBY_DATE |
SQL_TIMESTAMP |
14 |
6 |
TRANS_CODE |
SQL_VARCHAR |
2 |
7 |
TRANS_NAME |
SQL_VARCHAR |
6 |
8 |
TPTNER_ID |
SQL_VARCHAR |
35 |
9 |
VERSION |
SQL_VARCHAR |
12 |
10 |
ISA_TYPE |
SQL_VARCHAR |
5 |
11 |
INTERCHANG |
SQL_VARCHAR |
35 |
12 |
GROUP_NO |
SQL_VARCHAR |
35 |
13 |
TRANS_NO |
SQL_VARCHAR |
35 |
14 |
APP_RCV_CD |
SQL_VARCHAR |
35 |
15 |
APP_SND_CD |
SQL_VARCHAR |
35 |
16 |
RECV_CODE |
SQL_VARCHAR |
35 |
17 |
SEND_CODE |
SQL_VARCHAR |
35 |
18 |
RECV_QUAL |
SQL_VARCHAR |
4 |
19 |
SEND_QUAL |
SQL_VARCHAR |
4 |
20 |
ERRORS |
SQL_BIGINT |
10 |
21 |
STAT |
SQL_VARCHAR |
1 |
22 |
BYTE_COUNT |
SQL_BIGINT |
10 |
23 |
DIR |
SQL_VARCHAR |
3 |
24 |
FLOW_LEVEL |
SQL_VARCHAR |
5 |
25 |
RECORD_NAM |
SQL_VARCHAR |
10 |
26 |
RECORD_NO |
SQL_VARCHAR |
6 |
27 |
FIELD_NAME |
SQL_VARCHAR |
15 |
28 |
SEGMENT |
SQL_VARCHAR |
3 |
29 |
SEG_COUNT |
SQL_INTEGER |
10 |
30 |
ELEMENT |
SQL_VARCHAR |
2 |
31 |
SUBELEM |
SQL_VARCHAR |
2 |
32 |
SEV_CODE |
SQL_VARCHAR |
2 |
33 |
MSG_NO |
SQL_VARCHAR |
5 |
34 |
MSG_TEXT |
SQL_VARCHAR |
100 |
35 |
FILENAME |
SQL_VARCHAR |
160 |
36 |
FIELDVAL |
SQL_VARCHAR |
30 |
37 |
USER_IDENT |
SQL_VARCHAR |
35 |
38 |
ACK_EXPECT |
SQL_VARCHAR |
1 |
39 |
TR_ACK_TYP |
SQL_VARCHAR |
1 |
40 |
T_P_IND |
SQL_VARCHAR |
1 |
41 |
TRANS_CNT |
SQL_INTEGER |
10 |
42 |
FILEOFFSET |
SQL_BIGINT |
10 |
43 |
RCOUNT |
SQL_SMALLINT |
1 |
44 |
SNDR_ROUTE |
SQL_INTEGER |
14 |
45 |
SNDR_SUBID |
SQL_INTEGER |
35 |
46 |
RCVR_ROUTE |
SQL_INTEGER |
14 |
47 |
RCVR_SUBID |
SQL_INTEGER |
35 |
48 |
APPL_REF |
SQL_INTEGER |
14 |
49 |
PROC_PRIOR |
SQL_INTEGER |
1 |
50 |
COMM_AGM |
SQL_INTEGER |
35 |
51 |
APP_SND_QL |
SQL_INTEGER |
4 |
52 |
APP_RCV_QL |
SQL_INTEGER |
4 |
53 |
ASSOC_CODE |
SQL_INTEGER |
6 |
54 |
APP_PSWD |
SQL_INTEGER |
14 |
55 |
CLIST_VER |
SQL_INTEGER |
6 |
56 |
MSG_TYPE |
SQL_INTEGER |
6 |
Number |
Field name |
Field type |
Field precision |
|---|---|---|---|
1 |
RUN_NO |
SQL_BIGINT |
8 |
When an ODBC log database is used, the trace files are stored in the file TRNN.DAT in the current working directory (unless the -et switch is used to specify another directory). NN is the run number (RUN_NO field) from the RUN_ID table in the log database. RUN_NO is incremented for each run.
Number |
Field name |
Field type |
Field precision |
|---|---|---|---|
1. |
RUN_ID |
SQL_BIGINT |
9 |
2. |
ISA_SEND |
SQL_VARCHAR |
35 |
3. |
ISA_RECV |
SQL_VARCHAR |
35 |
4. |
GS_SEND |
SQL_VARCHAR |
35 |
5. |
GS_RECV |
SQL_VARCHAR |
35 |
6. |
GS_NUMBER |
SQL_VARCHAR |
35 |
7. |
ST_NUMBER |
SQL_VARCHAR |
35 |
8. |
TRANS_NAME |
SQL_VARCHAR |
3 |
9. |
SEGMENT |
SQL_VARCHAR |
3 |
10. |
SEG_NUMBER |
SQL_VARCHAR |
10 |
11. |
SEG_ERROR |
SQL_VARCHAR |
50 |
12. |
ELEM_NO |
SQL_VARCHAR |
2 |
13. |
SUBELEM_NO |
SQL_VARCHAR |
2 |
14. |
ELEM_ERROR |
SQL_VARCHAR |
50 |
