To query data on an IMS™ system,
you must first create a SQL script.
Procedure
To access IMS data:
- Import DBDs and PSBs from your local
file system or from z/OS®.
- Optional: Import COBOL copybooks
or PL/I includes.
- Open the Data perspective. From the main
menu, click .
Select Data, and click OK.
- Create a JDBC connection. In the Data Source
Explorer, right-click Database Connections folder,
and click New. Select IMS as the database manager and the IMS Universal JDBC driver as the JDBC driver.
- Select IMS Explorer project as
your Metadata source in the connection wizard. Specify the project
and the PSB. Click Finish.
- Create a data development project.
From the main menu, click .
- Create an SQL script. Right-click
the SQL Scripts folder and select .
Tip: More
graphical semantic help is provided if you use the query builder.