Rational Developer for System z


< 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. Right click anywhere in the SQL Query Builder, and select Run SQL from the context menu. The Specify Variable Values window opens.
  2. 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.
  3. 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.
< Previous | Next >

Terms of use | Feedback



This information center is powered by Eclipse technology. (http://www.eclipse.org)