Report on all group elements and list their subordinate elements
search cancel

Report on all group elements and list their subordinate elements

book

Article ID: 32745

calendar_today

Updated On:

Products

IDMS IDMS - Database

Issue/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?

Environment

Release: All supported releases.

Resolution

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;

Additional Information

(OLQ) Batch Processing

SQL Reference

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
    ;