The UPDATE NAME function can be useful if you use SQL to create tables. The SQL name for the table includes the specified or default authorization identifier of the user. The SQL name is in the format authid.sqlname, where AUTHID and SQLNAME are attributes of the occurrence. CA Datacom Datadictionary creates an occurrence name it can use by writing the CA Datacom Datadictionary name in the authid-sqlname format.
If the combined AUTHID and table SQLNAME is greater than the maximum allowed length of 32 characters, CA Datacom Datadictionary truncates the concatenated name. If the truncated name already exists, CA Datacom Datadictionary truncates it further and adds four zeros to the end of the name. CA Datacom Datadictionary increments the digits by one until the name is unique. For more information and examples, see the CA Datacom Datadictionary User Guide.
Note: For more information about how constraints are affected when you update the AUTHID or SQLNAME attribute-value, see Maintaining Tables with Related Constraints.
How to Use
When you select the UPDATE NAME 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 NAME : using _ ____________________________ : UPD NME : 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 specification on the Selection Criteria Fill-in panel according to the following description. Use the optional criteria box with the DISPLAY function only.
Use this field to specify the entity-type of the occurrence you are updating. You cannot use abbreviations in this field.
An existing entity-type
(No default)
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.
1- to 32-character RECORD or TABLE occurrence name
Generic selection
ALL
The name of the first RECORD or TABLE occurrence that meets the other selection criteria
Limit the selection to a specific occurrence by entering the name of the occurrence.
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 returns the occurrence or occurrences that meet the other selection criteria you enter on this panel. For more information, see the section about the order of returned occurrences.
1- to 32-character occurrence name
Generic selection
ALL
The name of the first occurrence that meets the other selection criteria
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.
TEST
T001—T999
PROD
001—999
ALL
The status/version of the first occurrence that meets the other selection criteria
Supply the password for this occurrence if this occurrence has password protection against unauthorized maintenance.
1- to 4-character password
(No default)
Supply the override code if this occurrence is restricted from unauthorized maintenance or retrieval with a lock level assignment.
1- to 4-character override code
(No default)
Newname Panel
After completing your entries, press Enter. If there are no errors, you receive an Occurrence Newname Change panel similar to the following. The panel has one field where you can enter the name you are assigning to the occurrence.
=> => => ----------------------------------------------------------------------------- DDOL: ANCHORED OCCURRENCE FOR NAME CHANGE TYPE OCCURRENCE STA VER TBL JONES-DEPTTBL T 001 -------------------------------------------------------------------------T16U DDOL Entity Occurrence Maintenance Occurrence Newname Change 1. Enter NEWNAME: _____ ___________________________ 2. Issue 'APPLY' command or press PF9 key to complete the change. PF1=HELP PF2=END PF3=CLARIFY PF4=PROCESS PF5=MENU PF6=STATUS PF7=SCB PF8=SCF PF9=APPLY PF10=PATH PF11=NEXT PF12=INPUT
After completing your entry, press PF9 (APPLY). If there are no errors, CA Datacom Datadictionary displays the Function Select panel with a message confirming successful completion of the function.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|