This document describes the format of the summary records copied to a sequential output file. It covers the following topics:
A fixed-length header is created for each record written to the sequential file. The format of the header is described in the following table:
| Offset | Length Bytes | Format | Explanation | |
|---|---|---|---|---|
| Hex | Decimal | |||
| 0 | 0 | 2 | Binary | Record Length |
| 2 | 2 | 2 | Binary | X'0000' |
| 4 | 4 | 3 | Alphanumeric | Eye catcher "SUM" |
| 7 | 7 | 1 | Alphanumeric | Record type "H" for header |
| 8 | 8 | 32 | Alphanumeric | Report name |
| 28 | 40 | 8 | Binary | STCK value when record gets written |
| 30 | 48 | 1 | Binary | Flag of trigger event:
X'01' -- report is closed or suspended |
| 31 | 49 | 1 | Binary | Unused |
| 32 | 50 | 10 | Alphanumeric | Date of first record (YYYY-MM-DD) |
| 3C | 60 | 8 | Alphanumeric | Time of first record (HH:MM:SS) |
| 44 | 68 | 10 | Alphanumeric | Date of last record (YYYY-MM-DD) |
| 4E | 78 | 8 | Alphanumeric | Time of last record (HH:MM:SS) |
| 56 | 86 | 2 | Binary | Database ID |
| 58 | 88 | 2 | Binary | Offset to data record |
| 5A | 90 | 6 | Binary | Unused |
This portion of the summary record varies, depending upon the fields used in the report. The schema describes the layout of the field data which follows afterwards. The format of the schema portion of the summary record is shown in the following table:
| Offset | Length Bytes | Format | Explanation | |
|---|---|---|---|---|
| Hex | Decimal | |||
| 60 | 96 | 2 | Binary | Record Length |
| 62 | 98 | 2 | Binary | X'0000' |
| 64 | 100 | 3 | Alphanumeric | Eye catcher "SUM" |
| 67 | 103 | 1 | Alphanumeric | Record type "S" for schema |
| 68 | 106 | 6 | Binary | Unused |
| 6E | 104 | 2 | Binary | Total number of fields |
| Varies +00 | Varies +0 | 8 | Alphanumeric | Field name (see the Field Reference)1 |
| +08 | +8 | 2 | Binary | Data length |
| +0A | +10 | 1 | Alphanumeric | Data format
C'B' -- binary |
| +0B | +11 | 1 | Alphanumeric | Field type
C'A' -- Account field |
1 The following fields use alternate names than the one listed in the field reference list.
| Field Name in the Field Reference | Field Name in the Summary Record |
|---|---|
| ADDITx | ADDx |
| FILE | FNR |
| IOS | IO |
| NATAPPL | LOG |
| NATPROG | PRO |
| NUCID | SMP |
| RESPONSE | RSP |
To determine the format of the variable portion of the record:
Refer to the report definition for each field (including virtual fields such as summary fields). Twelve bytes in total are reserved for the field name, the data length, the format of the field, and the field type.
This portion of the summary record varies, depending upon the fields used in the report. The data portion contains the contents of the fields that are described in the schema portion. The format of the data portion of the summary record is shown in the following table:
| Offset | Length Bytes | Format | Explanation | |
|---|---|---|---|---|
| Hex | Decimal | |||
| Varies +0 | Varies +0 | 2 | Binary | Record Length |
| +2 | +2 | 2 | Binary | X'0000' |
| +4 | +4 | 3 | Alphanumeric | Eye catcher "SUM" |
| +7 | +7 | 1 | Alphanumeric | Record type "D" for data |
| +8 | +8 | Varies | Binary/alphanumeric | Data portion for all fields, as defined in the schema portion. |
To determine the format of the variable portion of the record:
Refer to the schema portion of this record. For each report field, the data length and format are stored.
