Running Sql script from DB2CMD

[Cragu]

Hi Gurus,

I'm trying to extract the data from DB2 datas.

I used DB2CMD to connect from the CMD prompt
from there I'm running a batch file.

In that batch file, I will connect to the database and run the sql query.
Im using

db2 -v -td; -rabc.txt -fabc.sql

I'm haivng 30 sql scripts that will run in the batch file

I'm getting the correct output, the problem is...

Lets say for this abc.sql script the output is 10000 rows, I'm getting all the output int he cmd prompt as well in the output abc.txt file.
I want to see the output only in the txt file, and if I ran the script second time, the rows are appending... if I run the abc.sql script second time, I'm getting 20000 rows...

could any one help me in this issue, ... I'm very very new to DB2 I was unable to find the exact option.....

Thanks

Ragu

[ryanjsmith]

You should be able to do that by running the command

db2 -o- -tvf abc.sql -r abc.txt

The -o- will turn output off. You can view other options at

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0010410.html

Thanks,
Ryan