9.4.3.3.3.3 gg.handler.name.format.metacols
Specifies the metadata column values to appear at the beginning of the record, before any column data. Specify any of the following, in the order they should appear:
-
position – unique position indicator of records in a trail
-
opcode –
I,U, orDfor insert, update, or delete records (see:insertChar,updateChar,deleteChar) -
txind – transaction indicator – such as
0=begin,1=middle,2=end,3=whole tx (seebeginTxChar,middleTxChar,endTxChar,wholeTxChar) -
opcount – position of a record in a transaction, starting from 0
-
catalog – catalog of the schema for the record
-
schema – schema/owner of the table for the record
-
tableonly – just table (no schema/owner)
-
table – full name of table,
catalog.schema.table -
timestamp – commit timestamp of record
For example:
gg.handler.handler1.format.metacols=opcode, table, txind, position
Parent topic: Properties for CSV and Fixed Format Output