Accessing IMS data using SQL (without IMS catalog enabled)

To query data on an IMS™ system, you must first create a SQL script.

Procedure

To access IMS data:

  1. Import DBDs and PSBs from your local file system or from z/OS®.
  2. Optional: Import COBOL copybooks or PL/I includes.
  3. Open the Data perspective. From the main menu, click Window > Open Perspective > Other. Select Data, and click OK.
  4. 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.
  5. Select IMS Explorer project as your Metadata source in the connection wizard. Specify the project and the PSB. Click Finish.
  6. Create a data development project. From the main menu, click File > New > Data Development Project.
  7. 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.