Re: delimiters

In article <8743@emory.mathcs.emory.edu> kristen.m.altman@ccd.harris.com (Kristen Altman) writes: > >Informix fans, > >I am having a major problem with my application and I'm hoping that someone >can help. > >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 | > >etc... > > >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!! > >Thanks in advance > >Kristen Altman > >P.S. In Sybase, this is accomplished with the isql command. When you call >isql, you can specify a delimiter to separate the fields. Maybe there's >something similar in Informix that I don't know about (I hope). >-- >******************************************************* >* Kristen Altman * >* kma@ccd.harris.com * >* Harris Controls and Composition Division * >* Melbourne, FL * >******************************************************* the environment variable DBDELIMITER will allow you to change the delimiter on loads and unloads. to accomplish without an unload try writying an ace program to select all fields and some delimiter character, i.e. select field1,"!",field2,"!",... i have used this in the past and it has worked. Hope this helps. Chris ========================================================================= ciacovel@telesciences.com Zl pbzcnal cnlf zr gb guvax, ohg gurl ner abg erfcbafvoyr sbe zl gubhtugf =========================================================================