Is there a way to get the output of a db2 command into BOTH screen and a file ? or it has to be one OR the other ?

This is running a DB2 command from a command line like,

db2 "Select * from myschema.mytable"

or the DB2 commands from a shell sscript.


Thanks.

For a single command:

db2 -vz output_file "command"

For a script:

db2 -z output_file -tvsf script_file

Andy

Or you can use the "tee" command, which is exactly intended for things like that in a generic way.

Thank you both............I was leaning towards the "tee".

Since the script is a shell script with DB2 commands in it would,


./Myshell.sh | tee Result.out be Ok ?

Also, is there a way to add to output file and not replace it ?

Thanks again.

Never mind. -a would do it I think


./Myshell.sh | tee -a Result.out .............Thanks again......

Hi,
db2 -r output.txt -tvf sqlfile.sql

P.S. Don't forget executing the above command twice will append new records to output file.
Hope it helps,
Grofaty