Re: sp output to text file help

Posted in 1999

Sujit.Pal@bankofamerica.com — Wed, 08 Sep 1999 15:44:47 -0700 — source: Informix-list mailing list archive (1991-1998)

Michael If you have java and the Informix JDBC driver, you could use my jselect class to do this. It is available in the IIUG archives. You need to specify the style = pip(e delimited) and the query = "execute procedure sp_sample_proc". I think the SQLCMD by Jonathan Leffler may also do it, (and it is ESQL/C, which is guaranteed to be available) but I am not sure. HTH Sujit Michael Talbot <michael.talbot@telops.gte.com> on 09/08/99 01:32:41 PM Please respond to Michael Talbot <michael.talbot@telops.gte.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: sp output to text file help I have been asked to setup a shell script that will run about 10 sp's and save the output to a delimited text file. I am not sure if I can do something like the following: unload to 'a.txt' sp_sample_proc Does anyone have any suggestions?