Re: Loading database from script files
In article <199408101442.JAA01228@news.cs.utexas.edu>
sinues@prcd.prc.mrms.navy.mil "John Sinues" writes:
>I have an ASCII file containing a number of INSERT-INTO statements. I
>want to execute this file and load an Informix OnLine database. Two questions:
>
> 1. How can I load this script from the command line? Can I
> do something like this:
>
> isql -ansi {dbname} < {SQL_script.sql file}
isql -ansi <dbname> - - file
should do it (I've not tried it with -ansi though - you are probably the
only persoon in the world who actualy uses it :+> )
You don't need an EXIT the end of file will be detected.
FYI I found it useful to write a little ESQL program the just read lines
and did an EXECUTE IMMEDIATE on them so that I did not have to have isql
on all machines.
[You can also use dbaccess in exectly the same way as ISQL]
[STUFF DELETED]
--
Nick Hounsome