< Previous | Next >

Running the DB2 SQL query

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:

  1. Click anywhere in the SQL Query Builder to enable the Run SQL command on the SQL menu.
  2. Click SQL > Run SQL. The Specify Variable Values window opens.
  3. Double-click the Value cell in the :CUSTNAME row, and then enter the string John Doe in the cell.

    Specify Variables Window with 'John Doe' string entered in the Value cell

    After you press Enter, the name is automatically embedded in single quotation marks.
  4. Click Finish.
Your query runs, and the results are displayed in the SQL Results view.
< Previous | Next >

Feedback