Well, as it happens, SQSL (see http://www.4glworks.com/4wrcsqll.htm#FGWLANGREF
) allows you to do precisely that

Andy Kent wrote:
> I am writing a purge routine on a large table where we need to keep a
> copy of the purged rows. We also need to re-size the table extents. So
> the best bet would be to produce two ASCII files. Because of the size
> of the table I'd like to make as few passes through it as possible -
> one would be good.
>
> In an ideal world I'd have a piece of code that did something like
>
> foreach row
> if <to keep>
> unload (append) to ascii file1
> else
> unload (append) to ascii file2
> end foreach
>
> In an even more ideal world I'd do the whole thing in SPL. (HPL would
> be even better but the criteria are rather verbose and may need to be
> held in a memory-resident table).
>
> Given that we don't live in such Utopian conditions, what approach
> would give the best compromise?
>
> Thanks
>
> Andy Kent
>
>


--
Ciao,
Marco
__________________________________________________ ____________________________
Marco Greco /UK /IBM Standard disclaimers apply!

Informix faq http://www.iiug.org/techinfo/faq/informix.htm
4glworks http://www.4glworks.com
Informix on Linux http://www.4glworks.com/ifmxlinux.htm


sending to informix-list