How to report on all group elements and list their subordinate elements.

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

Introduction:

There is no DREPORT which reports specifically on the GROUP / SUBORDINATE structures among elements in a dictionary. How can I report on group elements?

 

Instructions

This can be achieved by using OLQ with an appropriately DIRL’ed dictionary (typically SYSDIRL) as the dictionary and the dictionary you want to run the report against as the database.

In this example, SYSDIRL is the DIRL’ed dictionary and APPLDICT is the dictionary against which the report is being run.

//SYSIPT DD *
SET ACCESS OLQ
SET DICTNAME SYSDIRL
SET DBNAME APPLDICT
SET UNDERLINE '-'
SIGNON SS IDMSNWKA SCHEMA IDMSNTWK ( 1)
SELECT G.INQ-NAM-058 AS GROUP, S.INQ-NAM-058 AS SUB FROM INQ-058 G,           -
ELEMNEST-087 N, INQ-058 S WHERE ELEMNEST-EXPL.G.N AND ELEMNEST-IMPL.S.N       -
ORDER BY 1
DISPLAY

If you use the CA-IDMS SQL Option and you have an SQL schema defined for the dictionary you wish to report on, you can also use this SQL query in OCF or IDMSBCF (APPLDICT is the name of the SQL schema defined for the dictionary):-

SET SESSION CURRENT SCHEMA APPLDICT;
SELECT G.INQ_NAM_058 AS GROUP, S.INQ_NAM_058 AS SUB
  FROM "INQ-058" G, "ELEMNEST-087" N, "INQ-058" S
 WHERE "ELEMNEST-EXPL".G.N AND "ELEMNEST-IMPL".S.N
 ORDER BY 1;                                              

Additional Information:

OLQ/Batch is described in the CA-IDMS OLQ Online Query Reference Guide, Chapter 11, “Batch Processing”.

For more information regarding the CA IDMS SQL Option, see the CA IDMS SQL Reference Guide.

An example of an SQL schema definition for a dictionary is as follows:-

 

CREATE SCHEMA APPLDICT
    FOR NONSQL SCHEMA SYSDIRL.IDMSNTWK VERSION 1
        DBNAME APPLDICT
    ;