I am trying to pass parameter values in a dbaccess command line that will run a .sql file on an AIX platform running Informix Dynamic Srvr. 9.4.

dbaccess (database name) file.sql (what is the syntax to pass parameter values to -- file.sql ?

Thanx AOT

You're probably better off doing a pre-process on your file using unix.

eg. let's say you have this in your original ' unload to /tmp/jon/x.unl select * from customers where creation_date >= :creation_date '

cat [original file] | sed 's/:creation_date/01-04-09/g' > /tmp/jon/tmp.sql

dbaccess dbname /tmp/jon/tmp.sql

rm -f /tmp/jon/tmp.sql

You're probably better off doing a pre-process on your file using unix.