Copying Source Members

Using the Interactive SQL Service Facility › Maintaining Source and Output Members › Copying Source Members

Copying Source Members

You can use the copy function of the Interactive SQL Service Facility to duplicate a source member. To copy a source member, either:

Select option 4 (COPY) on the SQLMAINT Panel.
Enter the CPY or COP margin command on the SQL Member List Panel. See Displaying Source and Output Members for details.
Enter the COP SQL command on the command line in Interactive SQL Service Facility. See COPY SQL Command for details.

If you select option 4 on the SQLMAINT Panel, CA Datacom Datadictionary displays the SQL Member Selection Criteria Fill-in Panel with the option you are requesting on the left of the panel. Use this panel to identify the source member being copied.

 =>
 =>
 =>
 
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLMAINT
 
                     SQL Member Selection Criteria Fill-in                  S02F
 
 
 COPY     SQL  / ________ , ________ , __________________ /
 CPY             (old   )   (new   )   (person - owner of old source member)
                 (source)   (source)
                 (name  )   (name  )
 
 
 
 
 
 
 
 PF1=HELP         PF2=END         PF3=SPLIT         PF4=PROCESS
 PF5=TOP          PF6=BOTTOM      PF7=BACKWARD      PF8=FORWARD
 PF9=EXECUTE      PF10=LEFT       PF11=RIGHT        PF12=ALTERNATE

Complete your specifications on the SQL Member Selection Criteria Fill-in Panel according to the following descriptions.

old source name

(Required) Enter the name of the existing member. If you receive this panel after entering a margin command on the SQL Member List Panel, the existing source member name is filled in.

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

new source name

(Optional) 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, you must 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)
old source name

person - owner of old source member

(Optional) 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 PERSON occurrence name
Default Value:: PERSON occurrence name associated with the person currently signed on to CA Datacom Datadictionary

Review your entry, and press Enter. CA Datacom Datadictionary automatically copies the member indicated and displays the SQL Member List Panel to display the members that currently exist. A message also displays on the message line indicating the status of the copy function.

 =>
 =>
 =>
 1-DDOL0000067I - SIFP - SUCCESSFUL SQL MEMBER COPY
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLMAINT
 
                           SQL Member List                                  S01N
                         Person= JONES
 
        Name      Type Description                      Updated  Lines
 ====== ========   =   ============ T O P =============  ======  =====
 000001 $DDSQL     O   CREATE MY SCHEMA                  112099  00004
 000002 DEPTTBL    O   DEPARTMENT ORGANIZATION TABLE     112099  00010
 000003 $DDSQL     S   CREATE MY SCHEMA                  112099  00001
 000004 DEPTTBL    S   DEPARTMENT ORGANIZATION TABLE     112099  00003
 000005 DEPTTBL2   S   DEPARTMENT ORGANIZATION TABLE     112099  00003
 ====== ========   =   ========= B O T T O M ==========  ======  =====
 
 
 
 PF1=HELP         PF2=END         PF3=SPLIT         PF4=PROCESS
 PF5=TOP          PF6=BOTTOM      PF7=BACKWARD      PF8=FORWARD
 PF9=EXECUTE      PF10=LEFT       PF11=RIGHT        PF12=ALTERNATE

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

Enter another source member name to copy.
Press PF2 (END) to return to the SQLMAINT Panel to select another option.
Press CLEAR to return to the Interactive SQL Service Facility Panel to perform another function.