Command line processor

The command line processor is a program that runs under z/OS® UNIX System Services. You can use the 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 command line processor is an alternative to using SPUFI or DSNTEP2 to execute SQL statements.

You can use the command line processor in one of the following ways:

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

Tutorial: Using the command line processor
You can interactively query and modify DB2 data, call stored procedures, and issue z/OS UNIX System Services commands through the command line processor. This lesson demonstrates how to perform those tasks.
Running the command line processor
If you use z/OS UNIX System Services, you can run the command line processor.
Command line processor ADD XMLSCHEMA DOCUMENT command
The command line processor ADD XMLSCHEMA DOCUMENT command adds one or more XML schema documents to an existing but incomplete XML schema.
Command line processor BIND command
The DB2 command line processor BIND command binds DBRMs that are in hierarchical file system (HFS) files into a package.
Command line processor CHANGE ISOLATION command
The CHANGE ISOLATION command changes the isolation level for SQL statements that the command line processor executes.
Command line processor CHANGE MAXCOLUMNWIDTH command
The CHANGE MAXCOLUMNWIDTH command changes the number of bytes in a table column that the command line processor returns.
Command line processor CHANGE MAXLINESFROMSELECT command
The CHANGE MAXLINESFROMSELECT command changes the number of rows that the command line processor returns.
Command line processor COMMIT command
The command line processor COMMIT command commits all SQL work since the previous commit or rollback operation, and releases any database locks that are currently held by the active connection.
Command line processor COMPLETE XMLSCHEMA command
The command line processor COMPLETE XMLSCHEMA command completes the registration of an XML schema.
Command line processor CONNECT command
The DB2 command line processor CONNECT command establishes a connection to a DB2 server.
Command line processor DESCRIBE CALL command
The DESCRIBE CALL command returns information about the parameters of a stored procedure.
Command line processor DESCRIBE TABLE command
The DESCRIBE TABLE command returns information about the columns of a table.
Command line processor DISCONNECT command
The command line processor DISCONNECT command closes the current connection to a DB2 server.
Command line processor DISPLAY RESULT SETTINGS command
The DISPLAY RESULT SETTINGS command lists the current settings for the maximum column width and the maximum number of rows that are returned for queries that the command line processor executes.
Command line processor ECHO command
The ECHO command writes the contents of a text string to the output stream.
Command line processor help command
The command line processor help command provides information about command line processor commands.
Command line processor LIST COMMAND OPTIONS command
The LIST COMMAND OPTIONS command lists command line processor option flags, and indicates whether those option flags are set to ON or OFF.
Command line processor LIST TABLES command
The LIST TABLES command lists tables, views, or aliases on a DB2 server.
Command line processor properties file
Use a command line processor properties file to set your own defaults for command line processor properties.
Command line processor REGISTER XMLSCHEMA command
The command line processor REGISTER XMLSCHEMA command registers an XML schema with the DB2 database manager.
Command line processor REMOVE XMLSCHEMA command
The command line processor REMOVE XMLSCHEMA command deletes a previously registered XML schema from the XML schema repository.
Command line processor ROLLBACK command
The command line processor ROLLBACK command rolls back all SQL work since the previous commit or rollback operation, and releases any database locks that are currently held by the active connection.
Command line processor SQL statements
Execute SQL statements in the command line processor after you issue the CONNECT command.
Command line processor start command
The command java com.ibm.db2.clp.db2 starts the DB2 command line processor.
Command line processor TERMINATE command
The TERMINATE command stops the DB2 command line processor.
Command line processor z/OS UNIX System Services command
A z/OS UNIX System Services command can be run in the command line processor can be run by preceding the command with an exclamation mark (!).
Command line processor UPDATE COMMAND OPTIONS command
The UPDATE COMMAND OPTIONS command changes property values for properties that have a value of ON or OFF.

Parent topic: DB2 commands

Setting up your system to use the DB2 command line processor

Related reference:

Statements