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.