Re: execute SQL from command line?
Posted in 1996
Alan Denney — — source: Informix-list mailing list archive (1991-1998)
In article <4pgq57$mdr@cssun.mathcs.emory.edu>,
mpeter <mpeter.muc@sni.de> wrote:
>> I am running SE 5.02, 4GL 4.12 on SCO 3.2v4.2
In other words, *no* ISQL, folks.
>> 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?
Since 5.0 and higher servers include DB-Access, you can run .sql scripts
using dbaccess, e.g.
dbaccess { <dbname> | - } [script.sql]
If the is not opened within the script, you must specify the database
name on the dbaccess command line.
--
Alan Denney aland@informix.com yosemite@netcom.com
I'm Pro-Anarchy... and I Vote!