GoldenGate

Hi,

I am trying to capture CSN and RSN in a token that will be used by flat file adapter. Each transaction needs to be written in flat file along with time stamp, transaction type, SCN and RSN. The extract is unable to capture SCN and RSN. Here's sample extract. Any pointers will be of great help:

EXTRACT EXTALL
USERID OGG, PASSWORD OGG
EXTTRAIL ./dirdat/ex
GETTRUNCATES
TABLE HR.test_seq, tokens (
TK-SCN = @getenv ("TRANSACTION" , "CSN"),
TK-RSN = @getenv ("TRANSACTION" , "RSN")
);

Thanks and rgds,
Avinash