FOR - NEXT loop next in load scripts

Mon, 13 Jun 2016 00:30:11 GMT

I'm trying to make load scripts including for-loop nested as below.

But it doesn't wok.

Is there anyboy who helps me to solve this?

Thank you for your cooporation,

For $(j)=1 to 3

LET i=1;

For $(i)=1 to 44

if j=1 or (j=2 and (i=1 or i=2 or i=4 or i=5 or i=20)) then

NTAB_temp:

LOAD

$(j) as j_count,

$(i) as i_count;

SQL SELECT *

FROM "sample_database".dbo.TABLEA;

endif

LET i=$(i)+1;

Next;

LET j=$(j)+1;

Next;

Jun from TOYKO

Re: FOR - NEXT loop next in load scripts

tamilarasu — Mon, 13 Jun 2016 07:58:02 GMT

Hi Jun,

I am not sure what you are trying to achieve. Try this,

For j =1 to 3

For i=1 to 44

if j=1 or (j=2 and (i=1 or i=2 or i=4 or i=5 or i=20)) then

NTAB_temp:

LOAD

$(j) as j_count,

$(i) as i_count;

SQL SELECT *

FROM "sample_database".dbo.TABLEA;

endif

Next