Re: How to extract to permanent table?

Posted in 1991

Walt Hultgren {rmy} — Sat, 16 Nov 91 15:05:23 -0500 — source: Informix-list mailing list archive (1991-1998)

Path: emory!swrinde!mips!sdd.hp.com!hp-col!col!judym From: judym@col.hp.com (Judy Miller) Newsgroups: comp.databases.informix Message-ID: <62980002@col.hp.com> Date: 13 Nov 91 23:58:02 GMT References: <62980001@col.hp.com> Organization: HP Colorado Springs Division Thanks for the email responses. What I didn't realize is that I can put more than one SQL SELECT statement in the Informix ACE report. >DETAIL: > > I have a shell script which first selects information into a TEMP table > and then runs an ace report: isql < my_select.sql > sacego -q my_report.arc > > I need the table to be permanent, not temporary, or the sacego will fail. I still have trouble finding what I need in the Informix manuals. Are there any 3rd party books you'd recommend? Judy Miller Hewlett Packard