Online Commands › COPY › In Interactive SQL Service Facility

In Interactive SQL Service Facility

You can duplicate a source member with the COPY command in Interactive SQL Service Facility. You can only copy source members. Output members cannot be copied. Use the following format for this command:

COPY (in Interactive SQL Service Facility)

►►─┬─ COPY ─┬─ SQL ───────────────────────────────────────────────────────────►
   └─ COP ──┘

 ►─ /old-source-name ─┬─────────────────────────────────────────┬─ / ─────────►◄
                      └─ , ─┬───────────────────┬─┬───────────┬─┘
                            └─ new-source-name ─┘ └─ ,person ─┘

/old-source-name

Enter the name of the existing source member.

Valid Entries:

1 to 8 characters

Default Value:

(No default)

new-source-name

Enter a valid source member name that is unique for the specified or current default person.

If the person is not specified with this command or is the same as the person currently signed on to CA Datacom Datadictionary, enter a new source name.

If the person is specified and is not the person currently signed on to CA Datacom Datadictionary, this field defaults to the old source name.

Valid Entries:

1 to 8 characters

Default Value:

(No default)

,person

Enter the name of the person who created the existing source member. If you leave this field blank, CA Datacom Datadictionary uses the name of the person currently signed on.

Valid Entries:

The first 18 characters of the 1- to 32-character occurrence name

Default Value:

PERSON occurrence name associated with the person currently signed on to CA Datacom Datadictionary

CA Datacom Datadictionary automatically copies the member indicated by the COPY command and displays the SQL Member List Panel to display the source members that currently exist. A message also displays on the message line indicating the status of the copy function.

After copying the source member, you can perform one of the following:

• Enter another source member name to copy on the SQL Member List Panel by using the COP or CPY margin command.
• Enter another SQL command on the command line.
• Press PF2 (END) to return to the SQLMAINT Panel, where you can select another maintenance function.
• Press Clear to return to the Interactive SQL Service Facility Panel to perform another SQL function.
• If you use the DEL margin command to place SQL source or output members in the online work queue, and then process the queue by entering PRO (PROCESS) in the command line, first use the EOF key to clear out the member name you just deleted before processing the next member.