You can display the contents of an IMS™ database as a table in the SQL Results view.
Procedure
To display the contents of a table in the SQL Results
view:
- In the IMS Explorer perspective,
open an IMS Explorer project.
- Import the program
specification block (PSB) and database descriptor (DBD) files for
the database into the project.
- Open the Data perspective.
- From the main menu, click .
- In the Select Perspective wizard, click Data.
- Click OK. The Data
perspective opens.
- 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.
- Under the connection that you created, expand the .
- catalog node
- The name of the PSB.
- schema node
- The name of the PCB.
- Right-click the table whose contents you want to display, and then select or . 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.