Re: ACE v/s SQL: query result outputting capability question

Atiqullah Hashmi wrote: > > Hi, > > We have an ace script that we use to do sql query, then some > data manipulation and then output the results using ACE's print > command. > This prints all these fields in concatenation and outputs a long > string. We need to convert this ACE script to a plain SQL script with > output in the same way, because we need to run it on both Informix and > Oracle (and Oracle doesn't have ACE). > Is it possible ? because running an sql query generates its own > output which we don't have ACE like control on. > > If it's possible, how it can be done ? There may be a better answer, but you <could> take the output of the SQL script, then run it through an AWK script (or something similar). It seems pretty simple to do in awk, though. Douglas Wilson ***Nobody's paying for these opinions, so they must be mine***