Hi all,

Dose anybody know how to execute filename.sql with variables ?

We usually execute filename.sql by command, db2 -vtf filename.sql; however, i want to bring variables into filename.sql for the name of database when connecting database, for example,

connect to %dbname

Well, I cound not find any info in command reference.

Please also give me a brife example.

Thank you so much !!

Sophie

This is not possible in a db2 script AFAIK ...

But you can do shell scripting or windows batch files to accompolish this ..

Eg:

#!/bin/ksh
connect to $1

HTH

Sathyaram

You probably meant:

#!/bin/ksh
db2 connect to $1

Thanks Nick, for point out ...

Cheers
Sathyaram

Thanks both anyway !!

Sophie