Topic
1 reply Latest Post - ‏2013-04-07T20:19:04Z by Rphilo
Porphyra
Porphyra
9 Posts
ACCEPTED ANSWER

Pinned topic CDC Subscriptions LiveAudit

‏2013-04-04T09:51:07Z |
Hi, 
 
I am using the mapping type Audit and would like to know if there is way to uniquely identify a record replicated by cdc? Like using the SEQNO?
  
tks  for the help
Updated on 2013-04-07T20:19:04Z at 2013-04-07T20:19:04Z by Rphilo
  • Rphilo
    Rphilo
    346 Posts
    ACCEPTED ANSWER

    Re: CDC Subscriptions LiveAudit

    ‏2013-04-07T20:19:04Z  in response to Porphyra
     Hi
     
    It depends on the source database. Different databases support the various system values in different ways and to different extents, as determined by the features offered by the database.
     
    For the iSeries. &SEQNO will hold the journal sequence number (when mirroring). However it may not be unique as when a journal receiver is rolled, the sequence number can be reset back to 0 for the new receiver. To be pretty much assured of generating a unique identifier you should also use the transaction &TIMSTAMP.
     
    For the zSeries, &SEQNO will be the LRSN or RBA when mirroring.
     
    I do not believe that &SEQNO is supported by any other database.
     
    Regards
     
    Robert