spooling multiple files by spooling within the iterations of a loop
Is there any way to spool files recursively within a loop and with different names?
<br>
what i wish to get is a set of files (a few hundred in number) containing the result of some queries and written out as some spooled files. so loosely, it should be something like this: </p>
<i>for j in 1.. someNum LOOP <br>
spool filename_j <br>
select whatever from that_table <br>
where something = this_value <br>
/ <br>
spool off <br>
end loop <br>
</i> <br>
<br>
here the name of the spooled files should be assigned from the iterations of the loop; like filename1, filename2, filename3, .... etc
</p>
any hints or ideas will be greatly appreciated! <br>