Using While or For Each in Load statement Tables

[#1]

I have 360 tables in SQL and i need 250, how i can extract this tables using something like Do while, for each..
example

Load *;
C1,
C2,
C3...

from $t1 ;
...to $t250

thanks in advance

[swuehl]

You may want to have a look at FOR...NEXT in the manual, probably something like following might work:

for counter=1 to 250 step 1

let tablename = '$t$(counter)';

load a,b from $(tablename);

next

Hope this helps,

Stefan