Use the IMS™ Explorer to run
a custom SQL query against the IVP Phone Book database.
Procedure
- 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.
- In the upper pane of the SQL Query Builder editor, enter
and run the following SQL statement:
SELECT LNAME, FNAME, ZIP FROM PCB01.A1111111
- Optional: You can also use the SQL Query Builder
to graphically build an SQL query statement.
- In the middle pane of the SQL Query Builder editor,
right-click and select Add Table.
- Select the table A1111111 to display all the columns
available for this table.
- Select the columns and specify a WHERE clause to create
the following SQL statement:
SELECT FNAME, LNAME, ZIP FROM PCB01.A1111111 WHERE LNAME > 'LAST2'
- To view the results in the SQL Query view, right-click
and select Run SQL.