Re: Missing UNLOAD

In article <8768@emory.mathcs.emory.edu> A.Heskett@bnr.co.uk (Tony Heskett) writes: > >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? Sorry, that feature was implemented only in the version ported to my imagination. |-: Anyway, what I *meant* was that a named pipe could probably be used in that context (I haven't tried it myself). Or, you can write an Ace report that outputs in unload format (use TOP MARGIN 0, BOTTOM MARGIN 0, PAGE LENGTH 1 and PRINT just the data and delimiters). >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 :-( Actually, your solution is great (assuming 4.X). I forgot about the "without headings" directive. In a quick 4.0 test, I still get blank lines before the data even with WITHOUT HEADINGS; I can't tell if that's proper behavior, my manuals are still packed up... >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 ? There were some problems in .03 and earlier tools with poor handling of suspend signals; all known ones were fixed in 4.0. >Tony Heskett th@bnr.co.uk Voice: (+44) 279 402637 >BNR, London Road, Harlow, Essex, CM17 9NA Fax: (+44) 279 454187 -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland "This song is a traditional bluegrass number, in the sense that it's about dead ancestors." - The Austin Lounge Lizards (live, introducing "Grandpa's Hologram")