I am using DB2

so once you connect to db2 run the following on unix prompt:

db2 -tvf query.file -z result.file

I dont remeber how to implement it on Oracle. But as far I can recollect:

sqlplus -s @username/password < $sql_file.sql > $sql_file.log

thanks
Sumeet