Re: Non-compiled SQL Scripts?

billy@west.co.za ("Billy Wheeler") wrote: :On 17 Apr 97 at 11:11, Joshua D. Molaver wrote: : :> It appears that 4GL and ESQL/C are both compiled languages. I need to able :> to send the SQL statements as text files and have them executed (via :> something like dbaccess or isql, from the command line) without any :> compilation procedures. Is this possible? : :Yep. Place your SQL commands in a text file, say do_it.sql. Then, :from the command line run: : :dbaccess yourdbname do_it But you forgot the following part of the post: :>I also need to be able to detect and :>respond to an error condition. which isn't supported. For this you need a language. If you don't want to use 4GL (or ESQL/C) you may be able to do it with Perl which is freely available from http://www.perl.com/perl/ There is a new special version/interface available for Informix. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org