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
, orD
for 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