Building SQL statements with SQL Assist

 

You can build your SQL statements interactively with SQL Assist in iSeries™ Navigator. SQL Assist can help you build SELECT, INSERT, UPDATE, and DELETE statements. To start SQL Assist, follow these steps:

1. Select SQL Assist from the Edit menu in the Run SQL Scripts window. In the SQL Assist window, you can choose tables to work with and build selection criteria. The statement is built in the bottom portion of the window.

2. Click OK to return the statement that you built to the Run SQL Scripts window.

3. Edit, run, and save your statement.

 

Parent topic:

Querying your database by running SQL scripts