RE: execute SQL from command line?
Posted in 1996
V. Lanny Rosicky — — source: Informix-list mailing list archive (1991-1998)
On Saturday, June 08, 1996, Joseph Kormann wrote...
> Matt Brickley (mbrickley@Infoave.Net) wrote:
> : I am running SE 5.02, 4GL 4.12 on SCO 3.2v4.2
>
> : Is there a way to execute sql from the command line, or a program that
> : you can pass the name of the database and a .sql file?
>
> : TIA
>
> : Matt Brickley
>
> isql dbname -qcr sql_to_run
> (the -qcr is what you would normally type after you got into the
database
> Query/Choose/Run)
>
> -Joseph
>
or more specifically, to the question:
$ echo `select WHATEVER from wherever` | isql dbname
Lanny