1. Oracle GoldenGate for Distributed Applications and Analytics
  2. Administer
  3. Parsing the Message
  4. Fixed Width Parsing
  5. Header

9.2.2.1 Header

The header must be defined by a copybook 01 level record that includes the following:

  • A commit timestamp or a change time for the record

  • A code to indicate the type of operation: insert, update, or delete

  • The copybook record name to use when parsing the data segment

Any fields in the header record that are not mapped to Oracle GoldenGate header fields are output as columns.

The following example shows a copybook definition containing the required header values

Example 9-1 Specifying a Header

01 HEADER.
20 Hdr-Timestamp            PIC X(23)
20 Hdr-Source-DB-Function PIC X
20 Hdr-Source-DB-Rec-ID    PIC X(8)

For the preceding example, you must set the following properties:

fixed.header=HEADER
fixed.timestamp=Hdr-Timestamp
fixed.optype=Hdr-Source-DB-Function
fixed.table=Hdr-Source-DB-Rec-Id

The logical name table output in this case will be the value of Hdr-Source-DB-Rec-Id.

Parent topic: Fixed Width Parsing