Iterno

[#1]

hi can any body explain iterno() function with simple example

[swuehl]

Maybe

LOAD

     Iterno() as RowNumber

autogenerate 1 While iterno() <=10;

From the HELP:

IterNo( )

This function is only meaningful if used together with a while clause, see Load. IterNo( ) returns an integer indicating for which time one single record is evaluated in a load statement with a while clause. The first iteration has number 1.

You can search the forum for iterno(), there are plenty of threads that use this function.

[jaimeaguilar · Accepted solution]

Iterno() only makes sense if used together with while. You can autogenerate rows, for example for creating a calendar, or creating records from another table. A real example would be having a table with mortgages contracts containing only the initial payment. With iterno() / while and some business rules you can generate the complete amortization tables,

an easy example would be:

Example:

Load iterno() as Counter

AutoGenerate 1

While iterno() < 10;

regards