Update Relationship

ENTMAINT Mode - Entity Maintenance › Update Occurrences › Update Relationship

Update Relationship

You can retrieve, update, add, or delete the relationship of an occurrence in ENTMAINT Mode. When you select the UPDATE RELATIONSHIP option, CA Datacom Datadictionary presents the following Selection Criteria Fill-in panel:

 =>
 =>
 =>
 1-DDOL000196A - CMPP - PLEASE COMPLETE REQUIRED INFORMATION FOR COMMAND
-----------------------------------------------------------------------------
 DDOL Entity Maintenance                 Selection Criteria Fill-in      T01F

                      ...................optional...........................
 UPDATE  RELATIONSHIP :   using  _                     ___________________ :
 UPD     REL          :   using   (A-alias)  (alias name)                  :
                      :           (D-descr)  (descriptor name)             :
                      :           (P-path)   (STANDARD)    (S-Sqlname)     :
                      :....................................................:

 / ________________________________ , ________________________________ .
   (entity-type)                      (parent occurrence-name)

   ________________________________ ( ____ ,      ,      ) /
   (occurrence-name)                 (stat,  pswd,  ovrd)
                                     (vers,  pswd,  ovrd)


 PF1=HELP   PF2=END  PF3=CLARIFY  PF4=PROCESS   PF5=MENU   PF6=STATUS
 PF7=SCB    PF8=SCF  PF9=APPLY    PF10=PATH     PF11=NEXT  PF12=INPUT

Fill in your specifications on the Selection Criteria Fill-in panel according to the following descriptions. Use the optional criteria box with the DISPLAY function only.

(entity-type)

Specify the entity of the occurrence you are updating. You cannot use abbreviations in this field.

Valid Entries:: An existing entity-type
Default Value:: (No default)

(parent occurrence-name)

When the entity you are selecting is FIELD, KEY, or ELEMENT, you can enter the name of a TABLE or RECORD occurrence in this field to limit your selection to the occurrences contained in a single table or record.

You can enter ALL to select all occurrences or use a generic selection of one or more of the initial characters of the name with an asterisk (*) to select several occurrences. For example, PAY* processes all occurrences of this entity-type with PAY as the first three characters in the name.

When you leave this field blank, CA Datacom Datadictionary uses the occurrence that meets the other selection criteria you enter on this panel. For more information about how CA Datacom Datadictionary returns occurrences, see the CA Datacom Datadictionary User Guide.

Valid Entries:

1- to 32-character RECORD or TABLE occurrence name

Generic selection

ALL

Default Value:

The name of the first RECORD or TABLE occurrence that meets the other selection criteria

(occurrence-name)

Limit the selection to a specific occurrence by entering the name of the occurrence.

When you leave this field blank, CA Datacom Datadictionary returns the occurrence or occurrences that meet the other selection criteria you enter on this panel. For more information about how CA Datacom Datadictionary returns occurrences, see the CA Datacom Datadictionary User Guide.

Valid Entries:

1- to 32-character occurrence name

Generic selection

ALL

Default Value:

The name of the first occurrence that meets the other selection criteria

(stat, or vers,)

Specify the status or version of the occurrence you are updating. When you leave this field blank, CA Datacom Datadictionary uses the status/version from the list below of the occurrence that meets the other selection criteria you enter on this panel. For more information about how CA Datacom Datadictionary returns occurrences, see the CA Datacom Datadictionary User Guide.

Valid Entries:: TEST
T001—T999
PROD
001—999
ALL
Default Value:: The status/version of the first occurrence that meets the other selection criteria

pswd,

Supply the password for this occurrence if this occurrence has password protection against unauthorized maintenance.

Valid Entries:: 1- to 4-character password
Default Value:: (No default)

(ovrd)

Supply the override code if this occurrence is restricted from unauthorized maintenance or retrieval with a lock level assignment.

Valid Entries:

1- to 4-character override code

Default Value:

(No default)

Relationship Maintenance Panel

After completing your entries, press Enter. If there are no errors, CA Datacom Datadictionary displays a Relationship Maintenance Procedure panel similar to the following:

=> => => ----------------------------------------------------------------------------- DDOL: Relationship Maintenance Procedure T08U 1. Select function: _ R - Retrieve U - Update A - Add D - Delete X - exit from relationship maintenance 2. Describe relationship: Relationship Name: ________________________________ relates this occurrence.... Type: JOB Parent: ________________________________ Name: LEDGER Status: TEST Version 001 ...to this occurrence: Type: ________________________________ Parent: ________________________________ Name: ________________________________ Status/Version: ____ ...with this intersection data: _________________________________________________________________________ 3. Issue 'APPLY' command or press PFKEY 9 to process. PF1=HELP PF2=END PF3=CLARIFY PF4=PROCESS PF5=MENU PF6=STATUS PF7=SCB PF8=SCF PF9=APPLY PF10=PATH PF11=NEXT PF12=INPUT

Complete entries on this panel according to the following descriptions:

Select function:

Specify one of the entries listed to the right of the panel.

Valid Entries:: A, D, R, U, or X
Default Value:: (No default)

Relationship Name:

Specify the name of the relationship that will connect the anchored occurrence to another occurrence.

Type:

Specify the entity of the occurrence to which you are adding a relationship with the anchored occurrence.

Parent:

Specify the RECORD or TABLE occurrence name only if the type is FIELD, KEY, or ELEMENT. We recommend that you do not relate a FIELD, KEY, or ELEMENT occurrence in a DATABASE structure with a non-Model occurrence.

Name:

Specify the name of the occurrence to which you are adding the relationship with the anchored occurrence.

Status/Version:

Specify the status or version of the occurrence.

...intersection data:

Fill in optional information that is pertinent to the relationship between the two occurrences.

Valid Entries:: 1 to 72 characters
Default Value:: (No default)

Relationship Add Subject/Object Inquiry Panel

After completing your entries on this panel, press PF9 (APPLY). If there are no errors, CA Datacom Datadictionary presents a panel according to the following conditions:

If you are adding a nonordered relationship or are deleting a relationship, CA Datacom Datadictionary gives you a message confirming successful completion of this function.
If the relationship is between two occurrences of the same entity-type, CA Datacom Datadictionary presents the following panel.
If you are adding an ordered relationship, CA Datacom Datadictionary displays the Ordered Relationship Add Sequence Information panel. For more information, see With Ordered Relationships.

=> => => ----------------------------------------------------------------------------- DDOL: Relationship Add Subject/Object Inquiry T81F Relationship Name: JOB-JOB-REQUIRES will relate....... Type: JOB Parent: ___________________________ Name: LEDGER Status: TEST Version 001 ...to........ Type: JOB Parent: ___________________________ Name: AR Status/Version: 001 _ Enter S or O to specify whether the second occurrence on the panel will be the subject or the object of the relationship. PF1=HELP PF2=END PF3=CLARIFY PF4=PROCESS PF5=MENU PF6=STATUS PF7=SCB PF8=SCF PF9=APPLY PF10=PATH PF11=NEXT PF12=INPUT

The Relationship Add Subject/Object Inquiry panel appears if the relationship you are adding is between two occurrences of the same entity-type, such as PROGRAM and PROGRAM. CA Datacom Datadictionary fills in the fields on this panel for you, except for the last field on the panel. Type S or O to specify whether the second occurrence on the panel is the subject or object of this relationship. After filling in the field, press Enter.