Informix : PAssing Paramters to a shell script

[Mute]

Does anybody know how to pass paramters to a Shell script . The documentation say use the prepare execute and free statements , but there are no good examples , only one using ESQL .

See example try below

echo 'prepare virt_obj from "unload to filename select * from tablename where colname = ?" '| /usr/informix/bin/dbaccess databasename

echo 'execute virt_obl using $1 " | /usr/informix/bin/dbaccess databasename

And in the same way I have used the free statement , but always get errors , ANYONE OUT THERE WITH SOME HELP !!!

 

[sanjaynahar]

make one file contains :-

dbaccess databasename <<!eot
select * from $1
!eot

may it help.

Sanjay