Table Copy Selection
The Table Copy Selection screen (see the following figure) appears when you select option 3 from the Utility Selection Menu.
Table Copy Selection Screen
From Table Area
Creator
ID of person who created the table or view to be copied.
Table Name
Name of the table, alias, synonym, or view to be copied. Wildcard characters (see Wildcard-Characters) can be used to display the Copy From Selection window (Copy From List of Tables).
To Table Area
Location
Db2 Subsystem Location ID of the table to which the data in the From Table is being copied to. If you leave the Location field blank, then the To Table Area is assumed to be on same subsystem to which File-AID for Db2 is connected.
Creator
ID of person who created the table or view to which you are copying.
Table Name
Name of the table, synonym, view, or alias to which you are copying. Wild card characters (see Wildcard-Characters) can be used to display the Copy To Selection window (Copy To List of Tables).
If you specify a table that does not exist, the Auto Create window appears (Auto Create Window).
Specify Selection Criteria Information Area
Selection Criteria Usage
Specify whether you want to use a previously saved selection criteria dataset. This allows you to develop your own WHERE clause conditions as criteria for the copy.
Specify the letter that represents the activity you want to perform:
T | Create Temporary selection criteria. The Criteria Display Format field determines the format used for the criteria. |
M | View or modify existing saved selection criteria. The criteria contained in the selection criteria dataset is displayed in the format specified by the Criteria Display Format field. |
E | Execute existing saved selection criteria. The criteria is not displayed. |
N | Do not apply selection criteria. All rows for the object are copied. |
Criteria Display Format
Specify whether selection criteria is to be entered on the Template, or as native SQL. This field only applies when the Selection Criteria Usage field is T (Temporary), or M (Modify).
Specify the letter that represents the activity you want to perform:
T | Selection criteria is processed using the Template. If you specified to Modify the Template in the Selection Criteria Usage field, then the SQL will automatically display with a message stating the SQL has been substituted. |
S | Selection criteria is processed in Edit using native SQL. |
Criteria Dataset Name
If you specify M (Modify) or E (Existing) Selection Criteria Usage, specify an existing sequential or partitioned dataset with RECFM=FB and LRECL=80. File-AID for Db2 prefills this field with the name of the last specified selection criteria dataset.
If you specify T (Temporary) Selection Criteria usage, a temporary data set (hlq.userid.SYSyyddd.Thhmmss.SHOW.SQL) containing the SQL source is created. An ISPF edit session is initiated, enabling you to edit the SQL. If you want to save the SQL source, you must use the ISPF CREATE or COPY command to a permanent data set before exiting the edit session. The temporary data set will be deleted when returning to the Table Copy Selection Screen.
Member
Specify the member of the data set you want to use. The field is prefilled with the last specified member name. If you leave this field blank or specify an asterisk (*), File-AID for Db2 displays the Member List for the data set. Specify a pattern, for example PART*, to narrow down the member list to the matching member names. The asterisk (*) is the only valid pattern character.
Specify Copy Options Area
Maximum Rows To Select
Enter the maximum number of rows to be copied.
Column Selection
Indicate whether you want to select columns to be copied. This option, for example, lets you map columns with like data types but unlike names. Enter Y when you want to copy only selected columns of similar or dissimilar tables/views. Column selection is ignored for the S option.
If you enter Y in this field, the Copy Column Selection screen (Copy Column Selection screen) appears. If you enter N, the Copy Row Selection screen (Copy Row Selection screen) appears.
Delete Existing Rows
Indicate whether you want to clear out all existing rows in the table you are copying to before the new rows are inserted.
Column Name Matching
Indicate whether the columns you are copying will be mapped to target columns with the same names. This option is convenient if you are populating a table or view that is defined the same as the one you are copying from, or if the FROM and TO tables or views have columns with matching names but a different order. Matching is ignored for the S option.
Discard Limit
Maximum number of From Table rows you want discarded before the copy process is halted. Enter zero, or any value up to 9999. A value of zero allows the entire input data set to be discarded if errors occur. If a non-zero value is entered, load processing will continue until the number of errors exceeds the specified value. The default is zero.
Use Uncommitted Read
Allows an application to bypass acquiring the locks that ensure no other user is updating the data being read. Bypassing the locks causes the application to run faster. The field is prefilled with the last specified value (YES or NO) or as specified with the UNCOMMITTED_READ_DEFAULT parameter of the Db2 Environment PARMLIB member. For more information, see UNCOMMITTED_READ_DEFAULT in the Db2 environment.
NO | Enter NO if you do not want the application to bypass acquiring the locks which ensure that no other user is updating the data being read. |
YES | Enter YES if you want the application to bypass acquiring the locks which ensure that no other user is updating the data being read. If you enter YES, the rows read by the application using uncommitted read could be invalid. |
Related topics