Running SQL queries against the phone book database

Use the IMS™ Explorer to run a custom SQL query against the IVP Phone Book database.

Procedure

  1. Create a custom SQL script by using the SQL Query Builder. In the SQL script, specify the SQL query statements to run against the IVP Phone Book database.
    1. In the upper pane of the SQL Query Builder editor, enter and run the following SQL statement:
      SELECT LNAME, FNAME, ZIP FROM PCB01.A1111111
  2. Optional: You can also use the SQL Query Builder to graphically build an SQL query statement.
    1. In the middle pane of the SQL Query Builder editor, right-click and select Add Table.
    2. Select the table A1111111 to display all the columns available for this table.
    3. Select the columns and specify a WHERE clause to create the following SQL statement:
      SELECT FNAME, LNAME, ZIP FROM PCB01.A1111111 WHERE LNAME > 'LAST2'
  3. To view the results in the SQL Query view, right-click and select Run SQL.




© Copyright IBM Corporation 2010, 2017.