Automated db2 commands in a shell script

[Siebbel]

Hello,

I posted this problem already in the linux section but without positive result. Perhaps someone here has experienced the smae problem.

I am pretty new with writing shell scripts and trying to use a script to perform some db2 commands on a CentOS 4 system. I get a problem when I put in my shell-file 'myscript.sh' the command:

db2 -tf somefile.sql
 

When executing, I get a DB2 error:

DB21004E You cannot specify both an input file and a command when invoking the Command Line Processor.
 

I discovered, using the debug command $ sh -x myscript.sh, that the shell adds some end of line symbols or something that ruin the command, since the output gives:

+ db2 -tf ctb2.sql $'\r'
 

Did anyone face similar problems once and know how to solve it? Thanks in advance, Siebbel.

[drvarcanin]

Hello,

I posted this problem already in the linux section but without positive result. Perhaps someone here has experienced the smae problem.

I am pretty new with writing shell scripts and trying to use a script to perform some db2 commands on a CentOS 4 system. I get a problem when I put in my shell-file 'myscript.sh' the command:

db2 -tf somefile.sql
 

When executing, I get a DB2 error:

DB21004E You cannot specify both an input file and a command when invoking the Command Line Processor.
 

I discovered, using the debug command $ sh -x myscript.sh, that the shell adds some end of line symbols or something that ruin the command, since the output gives:

+ db2 -tf ctb2.sql $'\r'
 

Did anyone face similar problems once and know how to solve it? Thanks in advance, Siebbel.

Try

db2 -tvf somefile.sql