Db2 command line processor return codes

The Db2 command line processor returns a return code after execution.

In interactive mode, a return code of 0 is always returned after the user terminates the Db2 command line processor.

The Db2 command line processor returns one of the following return (or exit) code after processing an input file in batch mode.

0
The Db2 command line processor commands or SQL statements executed successfully.
1
A statement was not terminated with the expected statement terminator.
255
All other errors, including invalid syntax, input file not found, and other error situations.