This is an example of the output messages that the Event Replicator Server will produce, in textual form. The URB* elements are attached together in top-down sequence.
Notes:
Message boundary:
URBH -- URBHMSNR = 1 Message sequence number for this
destination
URBS -- URBSST = 'STRT' Reptor status information
URBSTIME = Timestamp when URBS was created
Message boundary:
URBH -- URBHMSNR = 2 Message sequence number for this
destination
URBT -- URBTSNAM = 'SUBS1' Subscription name
URBTTSNR = 1 Transaction sequence number for this
subscription
URBTRCNT = 4 Record count in transaction
URBR -- URBRRSNR = 1 Record sequence number for this
transaction
URBRDCNT = 1 Data element count for record
URBRTYP = 'I' Insert
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'A' After image of record
URBDDATA = ... Record data
URBR -- URBRRSNR = 2 Record sequence number for this
transaction
URBRDCNT = 2 Data element count for record
URBRTYP = 'U' Update
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'B' Before image of record
URBDDATA = ... Record data
URBD -- URBDDSNR = 2 Data element sequence number
For record
URBDTYP = 'A' After image of record
URBDDATA = ... Record data
URBR -- URBRRSNR = 3 Record sequence number for this
transaction
URBRDCNT = 1 Data element count for record
URBRTYP = 'D' Delete
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'K' Before image of primary key
URBDDATA = ... Key data
URBR -- URBRRSNR = 4 Record sequence number for this
transaction
URBRDCNT = 2 Data element count for record
URBRTYP = 'U' Update
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'B' Before image of record
URBDDATA = ... Record data
URBD -- URBDDSNR = 2 Data element sequence number
for record
URBDTYP = 'A' After image of record
URBDDATA = ... Record data
URBE -- URBESNAM = 'SUBS1' Subscription name
URBETSNR = 1 Transaction sequence number for
this subscription
URBT -- URBTSNAM = 'SUBS1' Subscription name
URBTTSNR = 2 Transaction sequence number for
this subscription
URBTRCNT = 1 Record count in transaction
URBR -- URBRRSNR = 1 Record sequence number for
this transaction
URBRDCNT = 1 Data element count for record
URBRTYP = 'I' Insert
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'A' After image of record
URBDDATA = ... Record data
URBE -- URBESNAM = 'SUBS1' Subscription name
URBETSNR = 2 Transaction sequence number for
this subscription
URBT -- URBTSNAM = 'SUBS1' Subscription name
URBTTSNR = 3 Transaction sequence number for
this subscription
URBTRCNT = 1 Record count in transaction
URBR -- URBRRSNR = 1 Record sequence number for this
transaction
URBRDCNT = 1 Data element count for record
URBRTYP = 'D' Delete
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'B' Before image of record
URBDDATA = ... Record data
URBE -- URBESNAM = 'SUBS1' Subscription name
URBETSNR = 3 Transaction sequence number for
this subscription
Message boundary:
URBH -- URBHMSNR = 3 Message sequence number for this
destination
URBT -- URBTSNAM = 'SUBS2' Subscription name
URBTTSNR = 1 Transaction sequence number for
this subscription
URBTRCNT = 7 Record count in transaction
URBR -- URBRRSNR = 1 Record sequence number for this
transaction
URBRDCNT = 1 Data element count for record
URBRTYP = 'D' Delete
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'B' Before image of record
URBDDATA = ... Record data
URBR -- URBRRSNR = 2 Record sequence number for
this transaction
URBRDCNT = 1 Data element count for record
URBRTYP = 'I' Insert
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'A' After image of record
URBDDATA = ... Record data
URBR -- URBRRSNR = 3 Record sequence number for
this transaction
URBRDCNT = 1 Data element count for record
URBRTYP = 'I' Insert
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'A' After image of record
URBDDATA = ... Record data
URBR -- URBRRSNR = 4 Record sequence number for
this transaction
URBRDCNT = 1 Data element count for record
URBRTYP = 'I' Insert
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'A' After image of record
URBDDATA = ... Record data
URBR -- URBRRSNR = 5 Record sequence number for
this transaction
URBRDCNT = 2 Data element count for record
URBRTYP = 'U' Insert
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'B' Before image of record
URBDDATA = ... Record data
URBD -- URBDDSNR = 2 Data element sequence number
for record
URBDTYP = 'A' After image of record
URBDDATA = ... Record data
URBR -- URBRRSNR = 6 Record sequence number for
this transaction
URBRDCNT = 1 Data element count for record
URBRTYP = 'I' Insert
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'A' After image of record
URBDDATA = ... Record data
URBR -- URBRRSNR = 7 Record sequence number for
this transaction
URBRDCNT = 7 Data element count for record
URBRTYP = 'U' Update
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'B' Before image of record
URBDDATA = ... Record data
Message boundary:
URBH -- URBHMSNR = 4 Message sequence number for this
destination
URBC -- URBCSNAM = 'SUBS2' Subscription name
URBCTSNR = 1 Current transaction sequence number
URBCRSNR = 7 Current record sequence number
URBCDSNR = 1 Current data sequence number
URBD -- URBDDSNR = 2 Data element sequence number
for record
URBDTYP = 'A' After image of record
URBDDATA = ... Record data
URBE -- URBESNAM = 'SUBS2' Subscription name
URBETSNR = 1 Transaction sequence number for
this subscription
URBT -- URBTSNAM = 'SUBS2' Subscription name
URBTTSNR = 2 Transaction sequence number for this
subscription
URBTRCNT = 2 Record count in transaction
URBR -- URBRRSNR = 1 Record sequence number for this
transaction
URBRDCNT = 1 Data element count for record
URBRTYP = 'I' Insert
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'A' After image of record
URBDDATA = ... Record data
URBR -- URBRRSNR = 2 Record sequence number for this
transaction
URBRDCNT = 2 Data element count for record
URBRTYP = 'U' Update
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'B' Before image of record
URBDDATA = ... Record data
URBD -- URBDDSNR = 2 Data element sequence number
For record
URBDTYP = 'A' After image of record
URBDDATA = ... Record data
URBE -- URBESNAM = 'SUBS2' Subscription name
URBETSNR = 2 Transaction sequence number for
this subscription
Message boundary:
URBH -- URBHMSNR = 5 Message sequence number for this
destination
URBT -- URBTSNAM = 'SUBS1' Subscription name
URBTTSNR = 4 Transaction sequence number for
this subscription
URBTRCNT = 1 Record count in transaction
URBR -- URBRRSNR = 1 Record sequence number for
this transaction
URBRDCNT = 1 Data element count for record
URBRTYP = 'I' Insert
URBD -- URBDDSNR = 1 Data element sequence number
for record
URBDTYP = 'A' After image of record
URBDDATA = ... Record data
URBE -- URBESNAM = 'SUBS1' Subscription name
URBETSNR = 4 Transaction sequence number for
this subscription
Message boundary:
URBH -- URBHMSNR = 6 Message sequence number for this
destination
URBS -- URBSST = 'TERM' Reptor status information
URBSTIME = Timestamp when URBS was created