In Unix create a command file containing the following;

dbaccess 'DBNAME' -<<!
'SQL #1';
'SQL #2';
!

If the command file you created is called mysql.sh run it as follows;

nohup mysql.sh &

This will execute SQL #1 followed by SQL #2 (against database DBNAME) and save the output in a file named nohup.out

Make sure the last ! is the first character in the first column.

Thanks a lot Richman, I have just one more question, is it possible that i can package some scriptfiles and the .sql files together in the same commandfile and execute it, will the scripts get executed as well?

If I understand you correctly the answer is yes. The piece of code I supplied can be wrapped with unix shell commands. The stuff in between the !'s are for the database only - the remainder is for the shell. e.g.;

echo "`date` Selecting rows from table ABC . . ."

dbaccess 'DBNAME' -<<!
unload to abc.unl
select
*
from ABC
;
!

echo "`date` Selected rows from table ABC . . ."

I wrote the echo commands (in this case) to tell me what the sql is doing. Try it with your shell script(s). Happy Halloween!