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 to be reported 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 the SQL Option is installed and there is an SQL schema defined for the dictionary being used, this SQL query can be used 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;
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
;