At 01:05 PM 11/01/2006 +0000, you wrote:

>Hi,
>I have some code like EXECUTE STATEMENT 'EXECUTE PROCEDURE blabla'
>
>This procedure does a two table join and performs some value checking
>and inserting into a table in a FOR loop.
>
>The join produces aprox. 9000 records.
>
>While running this my pagefile grows until available disk space is
>exhausted.
>
>Anyone have any idea what can be the cause for this?

You're running what's sometimes known as "a runaway query" - in this case,
the procedure logic is probably executing an infinite loop. Show the
actual code of the two procedures so that it's possible to comment on what
the procedure is *actually* doing, rather than what you think it ought to do...

./heLen