The RID function returns the relative number of the record in a source datastore. This function can be used for counting the number of records read by the Integration Engine.
Category
Specialized
Syntax
RID()
Parameter and Description
This function has no parameters.
Example
Write an output message using the OUTMSG function once the number of source data records/rows read from datastore sourceds1 is equal to 10,000.
IF RID() = '10000'
OUTMSG(0, STRING('TEN THOUSAND RECORDS HAVE BEEN READ'))Map the relative source record number to target field TGT_RCD_ID in order to maintain a unique sequence number in the target datastore records.
TGT_RCD_ID = RID()