Re: execute SQL from command line?

Posted in 1996

Carlos Costa e Silva — 8 Jun 1996 00:57:43 GMT — source: Informix-list mailing list archive (1991-1998)

In article <mbrickley.4.00D6AB58@Infoave.Net>, mbrickley@Infoave.Net (Matt Brickley) writes: >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 I think for isql you can do: isql -s database -qcr sqlfile -- sqlfile without .sql for dbacces the command is: dbaccess database sqlfile or echo 'select * from table where ... ' | dbaccess database - Hope this helps. -- Carlos Costa e Silva <minimal@mail.telepac.pt>