Hi,

Every time when I try to execute command containing flags like f. ex:
-vf cte.db2 -t
I got an error:
DB21034E The command was processed as an SQL statement because it was not avalid Command Line Processor command.

Also when I am trying to load sql script from an external file, where do I put the .sql files on the filesystem (using win XP)?
-tf filename....

Best Regards

Typically most DBA's use:

db2 -tvf file_name.sql > file_name.out

Note that file_name.sql can be any file name, and does not have to have a file type of "sql". Neither does the output file have to have a file type of "out".

If you want to specify a different SQL delimiter (other than default ";"), then you can do this (assuming "@" is your delimiter).

db2 -td@ -vf file_name.sql > file_name.out

If your input file is in a different path than current path, you just specify the full path:

db2 -tvf c:\file_name.sql > file_name.out

Still cannot get the delimiters part.
I never used db2, now I am doing a simple exercise but it doesn't work.
f.ex:

"You can then enter SQL commands using the same db2 program. Use db2 -t to enter multiline SQL commands terminated by a semicolon.
# db2 -t "

each end every command I start with "-x" (whatever letter) produces an error.

I am especially interested to load sql scripts from fexternal files to do my exercising, but then again the command starts smth. like -tf, or -tvf and I get the same error:

DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command.....

command prompt modes???
never heard about it

DB2 Basics: Getting to know the DB2 UDB command line processor

thx