Re: piping scripts into isql revisited
Path: emory!swrinde!cs.utexas.edu!uunet!gossip.pyramid.com!pyramid!infmx!craigbr
From: craigbr@informix.com (Craig Browning)
Newsgroups: comp.databases.informix
Message-ID: <1992Jan13.193649.15202@informix.com>
Date: 13 Jan 92 19:36:49 GMT
References: <753@bellahs.UUCP>
Sender: news@informix.com (Usenet News)
Organization: Informix Software, Inc.
In article <753@bellahs.UUCP> jjamison@bellahs.UUCP (John Jamison) writes:
>Ok so I feel stupid. yes input redirection and piping worked without
>a problem. But I am told there is an undocumented flag which presents
>you with a ">" prompt or something, sort of a back door into isql
>in which you don't have all the menus and special keys, etc. And it
>will also take input from redirected input and a pipe.
>
>Thanks for all the responses so far,
>
>John Jamison
>--
>John Jamison : jjamison@bellahs.com
>
>Disclaimer: the opinions expressed herein are those of
>the author and not of his employer
The "isql - -" command Dave Cortesi mentioned will give you the ">" prompt
to work with in an interactive session.
A session could look something like this:
% isql - -
> database stores;
Database selected.
> select * from customer;
etc.
You can use a pipe, etc. for input instead of stdin as Dave mentioned.
I hope this helps,
Craig