DB2 client commond line options

Basic DB2 Command Line Options

There are options I used most frequently:

• -t   –terminated  – the statements are terminated with a delimiter. The default delimiter is the semi-colon

• -d  –delimiter     – the default delimiter is being overriden, and db2 uses the character immediately following d as the delimiter.

• -v  –verbose      – the statement will be echoed in output prior to the result of the statement.

• -s  –stop           – tells the command line processor to stop execution if errors occur while executing commands in a batch file or in interactive mode.

• -f   –file             – indicates that db2 should execute statements from a file, with the filename specified one space after the f.

For example
db2 -tvf /path_to_dir/sqlfile     -- execute SQL file where commands are terminated with default semicolon(;)
db2 -tsvf /path_to_dir/sqlfile   -- like above, but db2 will stop when first error is meet.

Detailed Options please refer to IBM document:

http://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0010410.html