The Db2 command line processor

The Db2 command line processor is a program that runs under z/OS® UNIX System Services. You can use the Db2 command line processor to execute SQL statements, bind DBRMs that are stored in HFS files into packages, call stored procedures, and perform XML schema repository operations.

The Db2 command line processor is an alternative to using SPUFI or DSNTEP2 to execute SQL statements. You can use it in interactive or batch mode:

  • In interactive mode, you request a single operation, and the Db2 command line processor executes that operation and returns the result.
  • In batch mode, you pass a file that contains all of the operations that you want to execute to the Db2 command line processor.