Running the command line processor

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

Before you begin

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

About this task

To run the command line processor:

1. Start the command line processor. See Command line processor start command.
2. 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.

3. Run command line processor commands. The 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	Command line processor SQL statements
   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 command line processor options	LIST COMMAND OPTIONS UPDATE COMMAND OPTIONS
   View or modify the format of the 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	Command line processor z/OS UNIX System Services command
   Display command line processor help	Command line processor help command

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