Command line processor plus (CLPPlus) provides a command-line
user interface that you can use to connect to databases and to define,
edit, and run statements, scripts, and commands.
CLPPlus complements the functions that the command line processor
(CLP) provides. CLPPlus includes the following features:
- Support for establishing connections to databases when you provide
a database user ID and password.
- A buffer that you can use to store scripts, script fragments,
SQL statements, SQL PL statements, or PL/SQL statements for editing
and then execution. You can list, print, or edit the text in the buffer
or run the text in the buffer as a batch script.
- A comprehensive set of processor commands that you can use to
define variables and strings that you can store in the buffer.
- A set of commands that retrieve information about a database and
database objects.
- The ability to store buffers or buffer output in a file.
- Multiple options for formatting the output of scripts and queries.
- Support for executing system-defined routines.
- Support for executing operating system commands.
- An option for recording the output of executed commands, statements,
or scripts.
CLPPlus
supports SERVER, SERVER_ENCRYPT, and KERBEROS authentication only.