How can I find the IIR Repository tables and fields being needed for my specific SQL query?

Document ID : KB000018984
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When an SQL query has been created to deliver specific information from the Datacom IIR Repository, the fields being needed for this query (and the tables in which these fields can be found) need to be identified.

Solution:

These steps can be used to identify the IIR field names and table IDs being needed for a specific SQL query:

  1. look into the reports of an IMS tools execution (e.g. DBA or DBO) to intentify the report fields being needed for your query

  2. look to the IMS tools' report headers which belong to the selected report fields which have been identified in Step 1

  3. go to the IIR User Guide, Appendix A "Table Information", and search all table descriptions for the report header you found in Step 2 (to identify the table containing the fields being needed for the SQL query)

  4. use the tables's "Description" column to identify the table field names of the fields being needed for your query