MAINTAINING THE DOMINO AND DB2 ENVIRONMENT


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.


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

Related topics