LOAD statements in for loops

[#1]

Hi all,

Just a quick one in case anyone knows. I am loading a table in a for loop in order to identify some values and use them one by one in another loop. For this to work I pretty much need the table to be flushed away after each iteration rather than just keep all rows that are added after each iteration. What's the best way to achieve this?

Thanks all in advance

[richard_chilvers]

Hi Joseph

Its hard to be certain about what you're trying to do without a bit more detail.

But it seems to me you want to empty a table and then re-use it. Would it be possible use

DROP TABLE xxxxxx

and then redefine it ?

Just a thought.

Regards

[#3]

Hi Richard,

Apologies I did not express it correctly and the error appeared to be somewhere else! Thanks anyway