Hello all, I have to create volatile tables in spool space. However I always exceed the spool space limit with my present code. I was wondering if there is any technique to flush the spool space to make some available temporarily.
Make sure you specify a suitable primary index in the volatile table definition to insure that your table is evenly distributed over the AMPs. The spool quota is enforced on each AMP. If too many rows go to one AMP, you get the out of spool error even if plenty of space is available on other AMPs.