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:
- Right click anywhere in the SQL Query Builder,
and select Run SQL from the context menu. The Specify Variable Values window
opens.
- Double-click theValue cell in the
:CUSTNAME row, and enter the string John Doe
in the cell. When you navigate away from the cell,
the entered name is automatically embedded in single quotation marks.
- Click Finish.
Your query will run, and two videos John Doe has checked out
will be displayed along with their due date in the SQL
Results view under the Result1 tab.