How to pass Unix command line variable to Informix SQL

[rsteffler]

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:

dbaccess <database name> test.sql 2

test.sql

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.

 

[sanjaynahar]

hi,

well, u can write a file in different way

file <ss> contains..

echo 'select * from ' $1 | dbaccess <database name>

$sh ss <table_name>

sanjay