Previous Topic: Running DSFNext Topic: Interactive SQL Service Facility


Retrieving Entity-Occurrences

When you retrieve entity-occurrences of multiple entity-types, you receive only the entity-occurrences of the entity-types you are authorized to access. All the other defined entity-occurrences are ignored.

For example, suppose your CA Datacom Datadictionary contains PROGRAM entity-occurrences A and B, and SYSTEM entity-occurrences X and Y. However, you have authorization to access only the PROGRAM entity-type. A CA Datacom Datadictionary online request to display an index of all entity-types would result in a display that includes PROGRAM entity-occurrences A and B. It would not show SYSTEM entity-occurrences X and Y.

In another example, suppose you request a path report through CA Datacom Datadictionary batch processing for an Index Report of the ORDER-ENTRY database and you only have access to DATABASE and TABLE entity-types. When you submit the following batch reporting commands, you would receive the following reports:

 -USR SAMPLE-USER,PSWD
 -DEF PATH,STANDARD
 -END
 -RPT START,DATABASE,ORDER-ENTRY(PROD),STANDARD
 -RPT INDEX
 -END

For an example report header, see Sample Report Headers.

The following are examples for pages 1 through 5.

User: SAMPLE-USER                     *********************************************************      DD Base:     2               *-----------------------------------------------------------------------------------*               *  CODE USER-NAME,PSWD,DATABASE-ID                                                  *               *  -USR SAMPLE-USER,****                                                   ;00PROC  *               *-----------------------------------------------------------------------------------*

User: SAMPLE-USER                     *********************************************************      DD Base:     2 -DEF PATH,STANDARD -END

User: SAMPLE-USER                     *********************************************************      DD Base:     2 -RPT START,DATABASE,ORDER-ENTRY(PROD),STANDARD -RPT INDEX -END

User: SAMPLE-USER                     *********************************************************      DD Base:     2 ENTITY-TYPE..................... OCCURRENCE...................... VRSN STS LK PSWD DESCRIPTION..........................    RECORD..........................     ELEMENT......................... DATABASE                         ORDER-ENTRY                      0003  P   0      ORDER-ENTRY DEMO DATABASE TABLE                            ACCTS                            0003  P   0      ORDER-ENTRY ACCTS TABLE TABLE                            CUST                             0003  P   0      ORDER-ENTRY CUST TABLE TABLE                            DETAIL                           0003  P   0      ORDER-ENTRY DETAIL TABLE TABLE                            ORDERS                           0003  P   0      ORDER-ENTRY ORDERS TABLE TABLE                            ITEMS                            0003  P   0      ORDER-ENTRY ITEMS TABLE TABLE                            ORD-NO                           0003  P   0      ORDER-ENTRY ORDER-NUMBERS TABLE TABLE                            RCPTS                            0003  P   0      ORDER-ENTRY RECEIPTS TABLE TABLE                            SHIPTO                           0003  P   0      ORDER-ENTRY SHIP-TO TABLE TABLE                            SLSHST                           0003  P   0      ORDER-ENTRY SALES-HIST TABLE                                         *--------  E N D   O F   J O B  -----------*

The full structure Index Report would include the AREA, KEY, ELEMENT, and FIELD entity-occurrences.

When you request entity-occurrences of a specific entity-type you are not authorized to access, you receive a UNA (user not authorized) CA Datacom Datadictionary Service Facility (DSF) return code or a CA Datacom Datadictionary error message.