Information file
One information file exists for each table for each company number. To read the information file, you can use the 4GL functions or the dictionary programs.
The information file contains the controlling information for the sequence files, called the information header, followed by the sequence headers of all the sequence files that are created.
The format of the information file name, where mmm means module code and nnn means table number:
a mmmnnn company number.inf
For example, the name for table ttadv999, company 0, is aadv999000.inf.
The structure of the information file is a header called information header, followed by multiple sequence headers, one for each sequence that is created.
Information header
| Field | Length (bytes) | Description |
|---|---|---|
| Version Information | 4 Str | Used by the audit server to store the version information. This must never be modified by any application by any means. |
| Table Name | 8 Str | Table for which audit information is stored. |
| Company Number | 2 Int | Company number of the table. |
| Status | 1 Int | The status specifies whether sequence reuse is permitted. |
| From Sequence Number | 2 Int | Audit-data will be stored in sequence files specified from this value. |
| To Sequence Number | 2 Int | The last sequence file after which sequence reuse is started or the user must take appropriate action such as deleting the existing file before reuse. |
| End Sequence Number | 2 Int | Specifies the last sequence that is written in the info file. This field is for internal use by the audit server only. The user must never change this by any means. Otherwise, the audit server will not work correctly. |
| Max. Size of 1 Audit File in Bytes | 4 Int | Specifies the maximum file size of a sequence file. |
| Security Level | 2 Int | Determines the users who have access to the information in the audit files. The security permissions regarding access to audit information are stored here. |
| Current Sequence Number | 2 Int | Determines the current sequence number that will be used to write the audit-data in the sequence file. |
| Offset in Current Sequence File. | 4 Int | Specifies the offset in the current sequence file where the audit-data will be written. |
| Reserved Space | 8 | This space is not used at present and is reserved for future use. Application programs must never use this space as this space may be used by a future release of audit server. |
| Length of Following Sequence Header | 2 Int | The length of the first sequence header in the info file. |
Sequence header
Each sequence file begins with a sequence header. The information file contains copies of sequence headers for all sequences that are created.
| Field | Length (bytes) | Description |
|---|---|---|
| Sequence Number | 2 Int | Specifies the sequence number of the sequence file. |
| Creation Date | 8 Str | Specifies the creation date, in UTC, of the sequence file in YYYYMMDD format. |
| Creation Time | 6 Str | Specifies the creation time, in UTC, of the sequence file in HHMMSS format. |
| Termination Date | 8 Str | Specifies the termination date, in UTC, of the sequence file in YYYYMMDD format. |
| Termination Time | 6 Str | Specifies the termination time, in UTC, of the sequence file in HHMMSS format. |
| Status | 2 Int | The status provides information to the user on whether
the sequence file was user-terminated or was closed because of DD change or
because a transaction data could not be accommodated in the sequence file. The
possible values are:
|
| Number of Transaction in the Sequence | 2 Int | Specifies the data of the number of transactions present in the sequence file. |
| Application Info - 1 | 4 | These bytes are reserved for storing data specific to the application. If the application must store any information in the audit files, these fields must be used to store that information. |
| Application Info - 2 | 4 | |
| Application Info - 3 | 4 | |
| Application Info - 4 | 4 | |
| Number of Fields Being Audited | 2 Int | Total number of fields being audited. |
| Number of Fields in Primary Index | 1 Int | Field information for all fields being audited is written below. First, the fields that are part of the primary index are written in the same sequence in which the fields are shown in the primary index. Next, all remaining fields are written in the order in which they occur in table DD. For example, if fields f1, f2, f3, and f4 are being audited and the primary index is on f4, f2, then field information will be written first for f4, and then for f2. Next the information will be written for all remaining fields. This field indicates the number of fields in the primary key. For example, for the previous example, the next field value must be 2 and the field layout is f4, f2, f1, f3. |
| <Field Data 1> | ||
| … | ||
| <Field Data n> | n = number of fields being audited | |
| Sequence Version | 4 Str | Change note: In Infor Baan IVc and earlier releases, the sequence version is not available. In that case, these four bytes are reserved space. |
| Audit_cols configuration ID | 4 | Identifies the
audit_cols configuration that was used to
create this sequence file.
|
| Length of Following Sequence Header | 2 Int | The length of the next sequence header in the info file. |
Field data
| Field | Length (bytes) | Description |
|---|---|---|
| Field Name | 8 Str | Name of the audited field |
| Field Type | 1 Int | Type of the field |
| Field Depth | 1 Int | Array depth of field |
| Field Length | 2 Int | Length of the field |