Re: delimiters

In article <8743@emory.mathcs.emory.edu> kristen.m.altman@ccd.harris.com (Kristen Altman) writes: |I need to be able to put a delimiter between the data fields returned from |a select statement. This data is being written to standard output. An |example would be: | |>isql testdb - |>select field1, field2, field3 from test; {where the delimiter is "|"} | |a |b |c | |d |e |f | | |My application uses only Informix-ISQL. | |If anyone has any idea how this might be accomplished (without using the |unload command), I would love to hear from you!! Why can't you use the UNLOAD command? I can't fathom anything you need to use it for that couldn't be accomplished with UNLOAD TO PIPE <pgmname> select field1, field2, field3 from test; |Thanks in advance |Kristen Altman -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland "Democracy means buying a house you can't afford with money you don't have to impress people you wish were dead." - Carson