There is no DREPORT which reports specifically on the GROUP / SUBORDINATE structures among elements in a dictionary. How can I report on group elements?
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
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;
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