Re: isql from shell
Clem W. Akins (cwakins@jabba.alloys.rmc.com) wrote:
> gary@lining.alt.ns.ca (Gary Langthorne) writes:
> > I have an old copy (rel2) of Informix/SQL that I wish to run a SQL
> >file from my unix prompt without entering the Informix menu system. Can
> >I do this? I found a file in the "lib" dir. called sqlexec but I try to add
> >a sript file after the command and the computer hangs.
> We use
> $ cat sqlfile.sql | isql dbname
> this returns the output to the stdout (screen).
DO NOT use sqlexec. When you use isql, IT uses sqlexec as it's backend.
A 1 process way is:
isql dbname script.sql
--
___
( _`\\ _ Danni Bauer
| | ) | _ _ ___ ___ (_)
| | | ) /'_` )/' _ `\\/' _ `\\| | bauer@gtetel.com
| |_) |( (_| || ( ) || ( ) || |
(____/'`\\__,_)(_) (_)(_) (_)(_) 73764.63@compuserve.com