Online Commands › COPY › In DBMAINT and FILEMAINT Modes

In DBMAINT and FILEMAINT Modes

Use the COPY function in the DBMAINT and FILEMAINT Modes to replicate a structure or substructure in another status. CA Datacom Datadictionary creates a new structure or substructure in the target status. You can use this function to create a PROD version or a new TEST version of a structure from an existing TEST version.

The COPY function is not valid with FIELD, KEY and ELEMENT occurrences. These occurrences are replicated with the TABLE or RECORD substructure when you copy it. You can use the COPY function with DATABASE, AREA, TABLE, FILE, RECORD, and DATAVIEW.

Note: To copy or restore a structure to TEST status from a history (HIST) or PROD status, use the RESTORE function. For more information, see RESTORE.

To copy an occurrence in the same status with a different occurrence name, enter the name of the existing occurrence in the LIKE field on the ADD or CREATE panels. For more information, see Add Structures.

Important! We recommend that you restore the structure or substructure from PROD status immediately before you change it to avoid any loss of information.

How It Works

When you use this function to create a PROD structure from an existing TEST structure:

• The original structure still exists in TEST status.
• The new structure is created and assigned a version number.
  • If this is the first-time the occurrence is copied to PROD status, CA Datacom Datadictionary assigns 1 as the version number.
  • The version number increases by 1 on each successive copy.
• CA Datacom Datadictionary marks the copies with the date and time that the PROD status occurrence was created. Use the date/time stamp to re-create the model of your PROD environment as it was on a given date and time by displaying or restoring the structure.
• CA Datacom Datadictionary changes the existing structure or substructure to HIST status. This HIST structure or substructure retains the version number it had as a PROD status structure or substructure. For more information, see the section about status and version in the CA Datacom Datadictionary User Guide.

Relationships

If the structure contains relationships with occurrences outside the structure, the relationships can not be copied with the structure or substructure. The copy-rule specified for the relationship determines whether the relationship is copied. For more information about relationship copy-rules, see the CA Datacom Datadictionary User Guide.

Constraints

In DBMAINT Mode, constraints are copied with the TABLE, AREA, or DATABASE entity-occurrence to which they are connected.

If you want to copy a TEST version of an occurrence to PROD status and the PROD status occurrence has constraints, first restore the PROD status occurrence to TEST, change and copy the occurrence to PROD status; or change the PROD status through SQL.

When you execute an SQL ALTER TABLE statement against a table that has a CONSTRAINT attribute-value of Y, CA Datacom Datadictionary sets the CONSTRAINT attribute to A on all TEST and HIST versions of that table. If you later attempt to copy one of these versions (or a structure containing one of these versions) to PROD status, CA Datacom Datadictionary prevents the copy, issues an error message, and identifies the table which has been altered. For more information and instructions, see Maintaining Tables with Related Constraints.

How to Use

Use the following format for this command:

Note: If your completed command exceeds the 76 spaces available in one command line, use the prompter panel to issue the command.

COPY (in DBMAINT and FILEMAINT modes)

►►─┬─ COPY ─┬─ entity ─ occ-name ─┬────────┬─┬─ STATUS xxxx ─┬─┬──────┬───────►
   └─ COP ──┘                     └─ FROM ─┘ └─ STA xxxx ────┘ └─ TO ─┘

 ►─┬─ STATUS xxxx ─┬─┬─────────────────┬─┬─────────────────┬──────────────────►◄
   └─ STA xxxx ────┘ ├─ PASSWORD xxxx ─┤ ├─ OVERRIDE xxxx ─┤
                     └─ PSWD xxxx ─────┘ └─ OVRD xxxx ─────┘

entity

(Required) Specify the entity for the occurrence you are copying.

Valid Entries in DBMAINT Mode:

DATABASE|BAS
AREA|ARA
TABLE|TBL
DATAVIEW|DVW

Valid Entries in FILEMAINT Mode:

FILE|FIL
RECORD|REC
DATAVIEW|DVW

Default Value:

(No default)

occ-name

(Required) Specify the occurrence name of the occurrence you are copying.

Valid Entries:

1- to 32-character occurrence name

Default Value:

(No default)

FROM STA xxxx

(Required) Specify the status of the existing occurrence.

Valid Entries:

T001—T999

Default Value:

(No default)

TO STA xxxx

(Required) Specify the status to which you are copying the occurrence.

Valid Entries:

T001—T999
PROD

Default Value:

(No default)

PSWD xxxx

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

Valid Entries:

1- to 4-character password

Default Value:

(No default)

OVRD xxxx

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

Valid Entries:

1- to 4-character override code

Default Value:

(No default)

Press Enter to complete the COPY function.