IBM Books

DB2 Connect User's Guide


Command Line Processor

The command line processor lets you issue SQL statements against a host or AS/400 database server, preceded by db2. For differences between host and AS/400 SQL and DB2 Connect SQL, see Host or AS/400 Server SQL Statements Supported by DB2 Connect and Host or AS/400 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 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 ]