Hi all,

I am writing one sql script where i am writing some db2 commands like connect ,select etc.

but I have to store output of select command inside another file and I want to execute the file from my script .

so please anyone tell me how to call another .sql file from a script on db2 command line.

I am using the command db2 -vtf filename to execute the file from db2 command window. but it is giving error when i trying to write the same cmd in file.

You cannot do what you want. The closest thing to that would be to invoke a new instance of CLP from within your script:
Be aware that it will create a new execution environment, meaning, in particular, that you will have to create a new connection.

you can not. you have 2 options:

1. put it in a script so you can call it from another script
just add 'db2 -<option> to your sql command.

2. put it in an sql file and call it from a script
for example: db2 -tvf file.sql

Thanks all,

I did it by creating a batch file and I put db2 commands inside it.

and run it from db2 command window.

thanks for your guidence....