Finding Datacom dataviews created on a Datacom table

Products

• Datacom
• Ideal

Issue/Introduction

The row layout of a table has changed which means that a new version of the Datacom dataviews on that table need to be created and then cataloged in IDEAL.

This article explains how to find that list of dataviews via a batch datadictionary utility.

Environment

Datacom Datadictionary all versions

Ideal

Resolution

Run DDUTILTY using following input cards:  

-USR DATACOM-INSTALL NEWUSER

-DEF PATH,DBMODEL

-DEF TRACE,TABLE.ELEMENT,$INTERNAL

-DEF TRACE,ELEMENT.DATAVIEW,$INTERNAL

-END

-RPT START,TABLE,your Datadictionary table entity name(PROD),DBMODEL

-RPT INDENT,DATAVIEW(PROD)

-END

Because dataviews are built from elements, and each element is a set of contiguous fields in a table, you can remove the “DATAVIEW” qualifier from the RPT INDENT command to see the relationships: 

-USR DATACOM-INSTALL NEWUSER

-DEF PATH,DBMODEL

-DEF TRACE,TABLE.ELEMENT,$INTERNAL

-DEF TRACE,ELEMENT.DATAVIEW,$INTERNAL

-END

-RPT START,TABLE,your Datadictionary table entity name(PROD),DBMODEL

-RPT INDENT

-END

For example, the report on the ITEMS table shows this:

TBL                              ITEMS

                                    ITEMS FILE

                                       SYSADM.ITEMS

   ELM                           ITEMS.BOQTY-ONORD

                                    B/O-QTY AND ON-ORD ELEMENT

      DVW                        ITMBO

                                    ORDER ENTRY DATAVIEW

   ELM                           ITEMS.DESC-ELEMENT

                                    DESC ELEMENT

      DVW                        ITMDESC

                                    ORDER ENTRY DATAVIEW

   ELM                           ITEMS.ITEMS

                                    FULL RECORD ELEMENT

      DVW                        ITEMS

                                    ORDER ENTRY DATAVIEW

      DVW                        ITMINQ

                                    OE ITEM RECORD READ ONLY

   ELM                           ITEMS.ITM-ID

                                    ITM-ID ELEMENT

      DVW                        ITMID

                                    ORDER ENTRY DATAVIEW  

 

Additional Information

For more information, see the online documentation in Indented Report