DOMINO AND DB2

Using SQL Assist to create an SQL statement
Use SQL Assist to quickly and accurately create an SQL statement. You can use SQL Assist to build or modify SQL SELECT, INSERT, UPDATE, or DELETE statements. Use the Access Plan feature to obtain a graphical representation of how the query resolves.

1. Open the IBM® DB2 Universal Database™ Enterprise Server Edition, Command Editor.

2. Click Add. The Specify Target dialog box appears.

3. Specify the target database from the displayed list.

4. If you are prompted to do so, enter a user name and password.

5. Use SQL Assist to create the SQL statement.

Note For information about the SQL Assist features, see the DB2 Information Center at http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/db2idxA.htm

6. (Optional) Click Access Plan to generate a graphical representation of how the SQL statement will resolve.

See also