Striim 3.10.1 documentation

GG Trail Reader sample code and output

Sample code:

CREATE SOURCE GgTrailReadSrc USING GGTrailReader (
  TrailDirectory:’./Samples/AppData/gg’,
  TrailFilePattern:’b1*’,
  DefinitionFile:’./Samples/AppData/gg/GGReadMultipleTables.def’,
  startPosition:’Filename:b1000000;offset:1039’,
  ExcludeTables :’QATEST.MULTTBL2’
)
OUTPUT TO GGTrailReadStream;

Sample output, insert:

data: ["1","CharInsert1         ","VCahrInsert1","1","1.1",[2000,4,22,0,0,0,0],
[2015,10,29,12,57,37,153],"NCharInsert1        ","NVCharInsert1","1"]
  metadata: {"TableID":0,"TableName":"QATEST1.MULTTBL3","TxnID":"2.17.1883",
"OperationName":"INSERT","FileName":"b1000000","FileOffset":1701,
"TimeStamp":1446103675037,"Oracle ROWID":"AAAXOvAAEAAAAyEAAA","CSN":"2222016",
"RecordStatus":"VALID_RECORD"}
  userdata: null
  before: null
  dataPresenceBitMap: "fwc="
  beforePresenceBitMap: "AAA="
  typeUUID: {"uuidstring":"01eaaa3d-0dc1-4b81-b8b4-acde48001122"}
};

Sample output, update:

  data: ["1","Update1             ","Update1","2","2.2",[1970,12,12,0,0,0,0],
[2015,10,29,12,58,39,327],"Update1             ","Update1",null]
  metadata: {"TableID":0,"TableName":"QATEST1.MULTTBL3","TxnID":"2.25.1884",
"OperationName":"UPDATE","FileName":"b1000000","FileOffset":3268,
"TimeStamp":1446103733953,"Oracle ROWID":"AAAXOvAAEAAAAyEAAA","CSN":"2222056",
"RecordStatus":"VALID_RECORD"}
  userdata: null
  before: ["1",null,null,null,null,null,null,null,null,null]
  dataPresenceBitMap: "fwM="
  beforePresenceBitMap: "AQA="
  typeUUID: {"uuidstring":"01eaaa3d-0dc1-4b81-b8b4-acde48001122"}
};

Sample output, delete:

  data: ["1",null,null,null,null,null,null,null,null,null]
  metadata: {"TableID":0,"TableName":"QATEST1.MULTTBL3","TxnID":"6.30.2195",
"OperationName":"DELETE","FileName":"b1000000","FileOffset":4379,
"TimeStamp":1446103861964,"Oracle ROWID":"AAAXOvAAEAAAAyEAAA","CSN":"2222189",
"RecordStatus":"VALID_RECORD"}
  userdata: null
  before: null
  dataPresenceBitMap: "AQA="
  beforePresenceBitMap: "AAA="
  typeUUID: {"uuidstring":"01eaaa3d-0dc1-4b81-b8b4-acde48001122"}
};