Running the Db2 command line processor

If you use z/OS® UNIX System Services, you can run the Db2 command line processor.

Before you begin

Before you can use the Db2 command line processor, your z/OS UNIX System Services session needs to be set up to locate the Db2 command line processor code and the properties file that contains Db2 command line processor start-up options. See Setting up the Db2 command line processor for details.

About this task

To run the Db2 command line processor:

Procedure

Start the Db2 command line processor.
See Start syntax for the Db2 command line processor.
Connect to a Db2 server using the CONNECT command.

You can disconnect from one server and connect to another server during the command line processor session by using the DISCONNECT command and another CONNECT command.

Run Db2 command line processor commands.

The Db2 command line processor lets you perform the following types of tasks:

Task	Command
Perform COMMIT, ROLLBACK, change isolation level, or DESCRIBE operations	COMMIT ROLLBACK CHANGE ISOLATION DESCRIBE CALL DESCRIBE TABLE
Execute other SQL statements, including CALL	SQL statements (Db2 command line processor)
Perform XML schema repository operations	REGISTER XMLSCHEMA ADD XMLSCHEMA COMPLETE XMLSCHEMA REMOVE XMLSCHEMA
Bind packages	BIND
List the tables on the Db2 server	LIST TABLES
View or modify Db2 command line processor options	LIST COMMAND OPTIONS UPDATE COMMAND OPTIONS
View or modify the format of the Db2 command line processor output	DISPLAY RESULT SETTINGS CHANGE MAXCOLUMWIDTH CHANGE MAXLINESFROMSELECT
Add explanatory information to the output	ECHO
Run z/OS UNIX System Services commands	z/OS UNIX System Services (Db2 command line processor)
Display Db2 command line processor help	Help for the Db2 command line processor

Stop the Db2 command line processor by running the TERMINATE command.