I am trying to pass a command line variable using dbaccess and cannot figure out how to get Informix to recognize the variable.
Here is what I am doing:
test.sql
Obviously, $1 does not work. How can I get my command line variable into the .sql script without generating the .sql on the fly or substituting using sed. Oracle accepts variables from the command line. I have to think that Informix will too.
Thanks.
Here is what I am doing:
Code:
dbaccess <database name> test.sql 2
test.sql
Code:
select * from home where type > $1
Obviously, $1 does not work. How can I get my command line variable into the .sql script without generating the .sql on the fly or substituting using sed. Oracle accepts variables from the command line. I have to think that Informix will too.
Thanks.