Re: how to run .sql files at unix command line

>From: twong@mips.com (Tony Wong) >Message-ID: <ksf32fINNqb0@spim.mips.com> >Date: 18 Mar 92 18:30:39 GMT >Subject: how to run .sql files at unix command line >X-Informix-List-Id: <newsgate.914> >Organization: MIPS Computer Systems, Sunnyvale, California > >I would like to know how you can run a .sql file using isql at the >unix command line - e.g. isql <database> -flags abc.sql > >The package I have is informix 4GL with RDSQL. I only know how to >do this interactively and I cannot find anything in the manual for the >above feature. This is actually discussed a while ago but I lost those >mails. Please help again. > >Thanks. > >Tony Wong What is wrong with Appendix I in the version 4.00/4.10 manual set? isql [-|database] [-qr] [command-file|-] The first arg is the database name; use - if the database is specified by the script. The -qr option indicates that isql should run a script, but is not actualy necessary. The second arg is either the script name (with or without the .sql suffix, but if not specified, the .sql suffix is added) or just - indicating read from standard input. Yours, Jonathan Leffler (johnl@obelix)