Please enable JavaScript to view this site.

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 Descriptions

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()