Re: isql commands from shell prompt

> > I have an Informix-SQL Version 4.00 in front of me. > > How do I issue the following command from inside a shell script? > > load from "add_units.data" insert into fgistatus;> > In which section is this discussed? > > I've never had an overview, and I can't seem to find what I need in the > index or by browsing each section's table of contents. > > Judy Judy From the command line this will work. %isql dbname < sql_file where dbname is the name of the database containing the table fgistatus and sql_file is a file containing SQL statements ie. the load command. Alternatively to reduce typing at the command line prepare the script to use a here docoment. So we have a file containing the following which we chmod +x:- isql dbname <<end_of_sql load from "add_units.data" insert into fgistatus; load from "another" insert into another_table;end_of_sql Substitute dbname. I am not sure where this is discussed in the manuals. Regards Adrian -- ------------------------------------------------------- #include "usual.stuff.h" Adrian Flynn ^^^^^ #include "disclaimer.h" Informix Software Ltd \\O-O/ #include "big.city.h" London >