Hi there,

I'm trying to execute the following sql file in my bash script

db2 -tf tables.sql >> createdb.log
db2 -tf foreign.sql >> createdb.log
db2 -tf indexes.sql>> createdb.log
db2 -tf data.sql>> createdb.log
db2 -td@ -f reqdelproj_block.sql>> createdb.log
db2 -td@ -f rqprojlock_delete.sql>> createdb.log
db2 -td@ -f rqprojlock_insert.sql>> createdb.log
db2 -td@ -f rqdrop_view.sql >> createdb.log
db2 -td@ -f rqdrop_views.sql >> createdb.log
db2 -td@ -f rqdelete_project.sql >> createdb.log

The script executes with no error message but when i check the log i see the following:

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

for all the sql calls. Doesn't look like it ran any of my files. Can anyone help please? Thanks in advance

First what is the DB2 version and OS?

Try running the commands like this in the script

db2 -tvsf sql_file -z output file

You will need to have a separate output file for each sql file but that should not be a problem.

Andy

I'm running DB2 v9.0 on Linux on intel.

so the script would look like this:

db2 -tvsf tables.sql -z output.txt

Yes, but more like this so it is easier to figure out what happened.

db2 -tvsf tables.sql -z tables.out
db2 -tvsf foreign.sql -z foreign.out
...

Andy

It's still giving me the same error message
DB21004E You cannot specify both an input file and a command when invoking
the Command Line Processor.

This sql is a series of CREATE statements.

Where is this error appearing? In the *.out files? or on the command line?

Andy

The script runs fine but when i check the out file that's where the error message is. When i logon to DB2 and do LIST TABLES i don't see any of the tables that were suppose to be created.

Can you post a script (just up to the first line that gives the error) and its corresponding out file?

Andy

Well i'm executing this in the script

db2 -tvsf tables.sql -z tables.out

And the out file is giving me this message:

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

Can you post tables.sql and tables.out?

Andy

Deleted code

Deleted code

Deleted code

It looks like it doesn't like -f (passing an input file) within a command line. I tried to take it out and it's complaining that an error occurred while accessing the file

I have scripts that look like that and they work fine. Please post:

1) the entire script
2) how you are executing the script
3) contents of tables.sql
4) contents of tables.out

Andy