ENTMAINT Mode - Entity Maintenance › Update Occurrences › Anchored Occurrence for Record/Table Field Maintenance Panel

Anchored Occurrence for Record/Table Field Maintenance Panel

After completing your entries on the Selection Criteria Fill-in panel for the UPDATE FIELD option with RECORD or TABLE entity-type specified, press Enter. If there are no errors, CA Datacom Datadictionary displays a FILE Maintenance Panel similar to the following panel.

Note: Access to this panel is not allowed for occurrences in PROD status. You can also update occurrences in PROD status using batch transactions. For more information, see the CA Datacom Datadictionary Batch Reference Guide.

For illustration, the following example is for a TABLE entity. The table containing the fields you define can be accessed by SQL applications if the fields you define meet the conditions noted in this section.

 =>
 =>
 =>
 --------------------------------------------------------------------------------
 DDOL: ANCHORED OCCURRENCE FOR TABLE  FIELD MAINTENANCE

 TYPE  OCCURRENCE  STA   VER
  TBL  ACCTS-REC    T    001
 ------------------------------------------------------------------   -------T03U
           Level    Field-Name                        DB Element-Name
           Preci    Type  Len    Repeat   Just Rdf Null Fill  (Num:Sign Type Dec)
 ====== == ======== ================== T O P ======= ===== ====================

 000001    1        ORD-ID
           00000    N     00005  00001  R     N   N               Y    C    000
 000002    1        BILL-DT
           00000    C     00006  00001  L     N   N               N    C    000
 000003    2        BILL-YR
           00000    C     00002  00001  L     N   N               N    C    000
 000004    2        BILL-MO       
           00000    C     00002  00001  L     N   N               N    C    000
 PF1=HELP   PF2=END  PF3=CLARIFY  PF4=PROCESS  PF5=MENU    PF6=STATUS    MORE....
 PF7=SCB    PF8=SCF  PF9=APPLY    PF10=PATH    PF11=NEXT   PF12=INPUT

If the display is longer than the screen, you can use the scroll commands or PF keys to move backwards and forwards through the display. Another panel to display the additional fields follows the description of the fields on this panel.

If FIELD occurrences have not been defined to the table or record, CA Datacom Datadictionary displays the above panel with only one line. Specify the attribute-values using the following descriptions and use the steps below to insert additional lines.

If FIELD occurrences have been defined to the table or record, you receive a FILE Maintenance Panel similar to the above panel. If the list of fields extends beyond the bottom of your screen, you can use the scroll functions to locate the desired FIELD occurrences in the display.

After completing your entries on the FILE Maintenance Panel, press PF9 (APPLY). If there are no errors, CA Datacom Datadictionary displays the Field Summary Display panel with the message confirming successful field maintenance. The Field Summary Display panel lists the FIELD occurrences, the attribute-values you specified and the attribute-values you allowed to default.

If an entry for a field is incorrect, you receive an error code in the column to the left of Level on the FILE Maintenance Panel when you press PF9 (APPLY). For more information about field maintenance error codes, see the CA Datacom/DB Message Reference Guide.