Viewing IMS data in the SQL Results view

You can display the contents of an IMS database as a table in the SQL Results view.

Creating an IMS Explorer project

To display the contents of a table in the SQL Results view:

  1. In the IMS Explorer perspective, open an IMS Explorer project.
  2. Import the program specification block (PSB) and database descriptor (DBD) files for the database into the project.
  3. Open the Data perspective.
    1. From the main menu, click Window > Open Perspective > Other.
    2. In the Select Perspective wizard, click Data.
    3. Click OK.
      The Data perspective opens.
  4. In the Data Source Explorer, create a database connection to the IMS system.
    Check with your IMS system administrator for the values of the database connection properties.
  5. Under the connection that you created, expand the database > Catalogs > catalog node > Schemas > schema node > Tables.
    catalog node
    The name of the PSB.
    schema node
    The name of the PCB.
  6. Right-click the table whose contents you want to display, and then select Data > Sample Contents or Data > Return All Rows.
    The SQL Results view displays the rows in a table based on the maximum number of rows specified in the Preferences window.
    Note: If your database definition includes STRUCTs or ARRAYs and the results do not include all of the sub-fields that you expect to see, modify your JDBC connection properties to set the optional flattenTables property to true. To modify your JDBC connection properties, see Connecting to an IMS database.