IBM Books

User's Guide


Command Line Processor

The command line processor lets you issue SQL statements against a DRDA server database, preceded by db2. For differences between DRDA server SQL and DB2 Connect SQL, see "DRDA Server SQL Statements Supported by DB2 Connect" and "DRDA Server SQL Statements Rejected by DB2 Connect".

You can also enter db2 with no SQL statement. This puts you into interactive input mode, where you can type SQL commands without prefixing them by db2. Enter quit to leave CLP interactive input mode,or enter terminate to end the command line processor and the database connection.

Before you can use the command line processor, it must be bound, as described in Chapter 4. "Binding Applications and Utilities".
Note:When using the command line processor in UNIX-based systems without being in interactive input mode, you must put double quotes around special characters (such as * and ?) when issuing SQL statements.

For more information on SQL commands, see the SQL Reference.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]