The CLPPlus processor is a new, easy to use, interactive command line processor for SQL statements and database commands. The processor provides support for dynamically creating, editing, and running SQL statements and scripts.
A set of commands is supported for connecting to databases, manipulating a statement or script defined in a buffer, modifying lines in the buffer, formatting result sets, and performing other related administrative tasks. This processor provides compatible features to the SQL*Plus command line processor.
DB2 V9.7 Fix Pack 1 expands on the functionality of existing CLPPlus features and adds support for: bind variables, COMPUTE functions, and commands to help customize report presentation.