Datacom

Hello .How would i know the list of  dataviews associated for a datacom table ?  Thanks!

Hi ,

You can run DDUTILTY in batch using sysin cards :

-USR DATACOM-INSTALL NEWUSER

-DEF PATH,DBMODEL

-DEF TRACE,TABLE.ELEMENT,$INTERNAL

-DEF TRACE,ELEMENT.DATAVIEW,$INTERNAL

-END

-END

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

-RPT INDENT,DATAVIEW(PROD)

-END

Regards,

Karina.

I am getting the below message :-

**** ERROR ****  RETURN CODE = DDTUUN0001  USER NOT KNOWN TO DICTIONARY

                                           12   12  MO14.0Y002015

                                                      00000000

           *----------------------------------------------------------------

           *                           CANNOT PROCESS USER

           *----------------------------------------------------------------

           *  CODE USER-NAME,PSWD,DATABASE-ID

           *  -USR DATACOM-INSTALL *******

So do we need to provide any additional information ?  Thanks!

Ok. Thanks got corrected .  Thanks!

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 table name(PROD),DBMODEL

-RPT INDENT

-END

For example, the ORDERS table will show 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

Don Johnson

Principal Support Engineer, CA Datacom product family

Office: +1 609 583 9673 (x49673) | Mobile: +1 304 237 8439 | Donald.JohnsonJr@ca.com

<mailto:Donald.JohnsonJr@ca.com>[CA]

<http://www.ca.com/us/default.aspx>[Twitter]<http://twitter.com/CAInc>[LinkedIn]<http://www.linkedin.com/company/1372?goback=.cps_1244823420724_1>[Facebook]<https://www.facebook.com/CATechnologies>[YouTube]<http://www.youtube.com/user/catechnologies>[Google]<https://plus.google.com/CATechnologies>[Slideshare]<http://www.slideshare.net/cainc>

If you are not interested in ELEMENT names and would like to obtain the list of the dataviews only, you can slightly modify the PATH definition, adding a SKIP parameter to the first TRACE statement:
-USR DATACOM-INSTALL NEWUSER
-DEF PATH,DBMODEL
-DEF TRACE,TABLE.ELEMENT,$INTERNAL,SKIP
-DEF TRACE,ELEMENT.DATAVIEW,$INTERNAL
-END
-RPT START,TABLE,your table name(PROD),DBMODEL
-RPT INDENT
-END

The INDENT report for the ITEMS table will show:

TBL                              ITEMS                      
                                    ITEMS FILE              
                                       SYSADM.ITEMS         
      DVW                        ITMBO                      
                                    ORDER ENTRY DATAVIEW    
      DVW                        ITMDESC                    
                                    ORDER ENTRY DATAVIEW    
      DVW                        ITEMS                      
                                    ORDER ENTRY DATAVIEW    
      DVW                        ITMINQ                     
                                    OE ITEM RECORD READ ONLY
      DVW                        ITMID                      
                                    ORDER ENTRY DATAVIEW    

Best regards, Umberto

If you run with -RPT INDENT,DATAVIEW(PROD)   as mentioned in my original answer then there is no need to mention SKIP on the table to element relationship .

Regards,

Karina.

TEC1878436 created from this question.