Before you incorporate the SQL query into the video store
application, you need to test the query to ensure that it returns
correct results. You can do this by using the SQL Query Builder.
To run the DB2® SQL
query:
- Click anywhere in the SQL Query Builder to enable the Run
SQL command on the SQL menu.
- Click . The Specify Variable
Values window opens.
- Double-click the Value cell in the
:CUSTNAME row, and then enter the string John Doe
in the cell.

After
you press Enter, the name is automatically embedded in single quotation
marks.
- Click Finish.
Your query runs, and the results are displayed in the SQL
Results view.