Using the Loop Step Type

You can bind the Loop step type to the DataLoader. To bind the Loop and DataLoader, add the variables which are defined in the DataLoader into related steps inside the Loop. PTF binds them automatically.

The total query result rows is assigned to the rowcount parameter which is used for the Loop step type.

Consider the following when you use the Loop step type with the DataLoader step type:

• If rowcount related variable is used to control Loop, all the steps which are in the Loop step type and use the variables defined in the DataLoader is run multiple times till the loop count is equal to the number of returned rows of the query.

• If there are duplicate rows in a query result, PTF considers them as different rows and runs twice.

Example

This example illustrates using the Loop step type with the DataLoader step type.

Type	Action	Recognition	Parameters	Value
DataLoader	Load	name=S6	source=HMAP_EMPL_PHOTO;ownType=public;sourceType=NMQ;rowcount=&rowcount;
Loop	For	&Idx = 1 to &rowcount