Re: Running SQL from unix shell script
Try a "here document" i.e.
dbaccess [dbname] - << !
{
Any valid SQL statement(s);
}
! #Note this must be 1st char on new line
To run a .sql from command line.....
dbaccess dbname < file.sql
(or isqlrm, isql which ever you have)
Terence P. Hillick
V.P. CSCS, Inc.
thillick@aol.com