Entering and executing SQL statements using CLP

The QBE command line processor (CLP) is no longer supported. The standalone Command Line Processor is recommended for entering and executing SQL statements.

Procedure

To enter and execute SQL statements:

1. Tap the MENU icon, then select CLP from the Tools menu. The DB2 Everyplace CLP window opens.
2. In the query field, specify an SQL statement. For example, to select the contents of the VNPERSON table enter:

   SELECT * FROM VNPERSON
   

3. Tap Run SQL.

Related tasks

• Importing and exporting data using the CLP

Related concepts

• Overview of the CLP application

Related reference

• CLP commands
• Overview of IBM Sync