Missing UNLOAD

Walt Hultgren writes (quoting Alan Denney): > >Why can't you use the UNLOAD command? > > > > UNLOAD TO PIPE <pgmname> select field1, field2, field3 from test;> > I would also use the UNLOAD command if possible, but my ISQL (4.10.UC1) > won't unload TO PIPE -- would that it could! Will it in a later release? Alan, you're not thinking of something like: output to pipe "tr '[a-z]' '[A-Z]'" without headings select * from gen_ids; are you ? Or 5.0 ? Since mine doesn't work either :-( Around about now seems to be a good time to make a FIFO and do the unload down that, if you really want to play this way. The original post said *without* using an UNLOAD, tho'. > Maybe you could unload to a temp file, then go from there. Don't forget > that UNLOAD strips trailing blanks from char fields, if that's important. Hmm ... and the adding-the-pipes stuff adds lotsa space: even select num, "|" d, code from gen_ids; won't give me better than this, which is probably a good deal worse ... num d code 11 | PU 12 | UL Remember to declare nice big variables, I suppose, if you need to go this way, and watch out for the "leading blanks on the following fields", if you see what I mean. Could some kind soul please tell me, BTW, why hitting ^Z completely mangles my isql display ? I was hoping it'd just stop it temporarily, but it's never the same again. Is it fixed in slightly-less antique software, or just something really dim I'm doing ? isql -V: INFORMIX-SQL Version 2.10.03K Copyright (C) 1984-1988 Informix Software, Inc. All Rights Reserved Software Serial Number INF#R159412 $SQLEXEC -V: INFORMIX-OnLine Version 4.00.UH1 Wed Jan 30 15:11:39 PST 1991 Software Serial Number LEX#C144281 Happy Easter, folks, may all your eggs be Big ones. Cheers - Tony. __________________________________________________________________________ Tony Heskett th@bnr.co.uk Voice: (+44) 279 402637 BNR, London Road, Harlow, Essex, CM17 9NA Fax: (+44) 279 454187