Accessing IMS data using SQL (with IMS catalog enabled)

To query data on an IMS catalog-enabled system, create an SQL script.

Procedure

To access IMS data:

  1. Populate the IMS catalog.
  2. Open the Data perspective. From the main menu, click Window > Open Perspective > Other. Select Data, and click OK.
  3. 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.
  4. Select IMS catalog as your Metadata source in the connection wizard. Specify the PSB name. Click Finish.
  5. Create a data development project. From the main menu, click File > New > Data Development Project.
  6. Create an SQL script. Right-click the SQL Scripts folder and select New > SQL or XQuery Script.
    Tip: More graphical semantic help is provided if you use the query builder.




© Copyright IBM Corporation 2010, 2017.