Re: Want pipe delimiters to STDOUT
Posted in 1995
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
In article <442ikg$q5h@nntp5.u.washington.edu>,
Y. Wu <siwu@u.washington.edu> wrote:
}
} I am using an informix database on a remote machine
} to feed streams of text to post-processing code on
} the local machine. The scheme works well, and I am
} trying to improve the efficiency of the code.
}
} I am looking for some ISQL code that will simply
} print values (WITHOUT HEADINGS), pipe delimited,
} and terminated with a newline to STDOUT. I don't
} want the three blank lines at the top of the stream
} either. In other words, I want just pure data, with
} no labels or formatting.
Check out Dave Snyders Web Page and grab dblist.
http://www.ece.vill.edu~/dave/
or FTP emory.mathcs.edu (think thats right?)
dblist is a program that will dump the data from a given
table to the screen. It has options for other cool stuff
as well like size and length of record. It will run
update statistics first before the data is retrieved.
dblist comes as a shell archive and after unpacking will
need to be compiled with cc or or esql
--
Doug
--------------------------------------------------------------------------------
Douglas Probst @ catseye (Home of the crazy cat lady) - Upper Darby, PA
INTERNET: doug@catseye.pha.pa.us