SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 07:23 AM
| ||||
| ||||
 Re: Unloading to two destinations Marco Greco said: > Well, as it happens, SQSL (see > http://www.4glworks.com/4wrcsqll.htm#FGWLANGREF > ) allows you to do precisely that ....not to blow your own horn, or anything...  )> 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 > -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco If anyone told you to be yourself they would be giving you bad advice. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed sending to informix-list      |
Linear Mode
