Sample: accessing the phone book database with the Data Source Explorer and SQL Query Builder

This sample shows how to access the IVP Phone Book database using the Data Source Explorer and SQL Query Builder from IMS™ Explorer.

Prerequisites

  • The IMS system administrator must run the IMS IVP jobs to install the IVP Phone Book database in your IMS system.
  • The IMS system must be configured to support the IMS Universal drivers.

Getting the sample files

You can find the sample files in your IMS Explorer installation directory, under the location <installaion location>\IMS Explorer samples.

Import the following program specification block (PSB) and database description (DBD) files into your IMS Explorer project:

DFSIVP1.txt
PSB for the IVP Phone Book database.
IVPDB1.txt
Physical DBD for the IVP Phone Book database.
IVPDB1I.txt
Logical DBD for the IVP Phone Book database.

Sample scenario

In this scenario, you want to retrieve the first six rows of data that are stored in the IVP Phone Book database by using the Data Source Explorer. You also want to create and run custom queries against the database by using the SQL Query Builder.




© Copyright IBM Corporation 2010, 2017.