Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 Tools : COPYTABLE_APPL

COPYTABLE_APPL
Copies selected occurrences from a source table to a destination table. (E)
Invocation
Do one of the following:
The following screen appears when COPYTABLE_APPL is executed:

 
Rule Execute Utility COPY TABLE
 
 
 
Source Table Name ===>
 
Destination Table Name ===>
 
 
Select Occurrences Where
===>
 
 
 
 
 
 
 
 
 
 
 
PFKEYS: ENTER=COPYTABLE 1=HELP 3=EXIT 12=EXIT

 
Usage Notes
Only those fields with the same name in both the source and destination tables are copied. If the occurrence already exists in the destination table, the occurrence is replaced.
When copying IDgen tables, the IDgen key values are regenerated on the target table. IDgen key values are not changed if batch utilities are used.
The syntax for selection is <field name> <relational operator> <value>.
Example
The following entries to the prompt screen copy all occurrences from the table EMPLOYEE_DEPT(10) to the table EMPLOYEE_DEPT(30):

 
Rule Execute Utility COPY TABLE
 
 
 
Source Table Name ===> EMPLOYEE_DEPT(10)
 
Destination Table Name ===> EMPLOYEE_DEPT(30)
 
 
Select Occurrences Where
===>
 
 
 
 
 
 
 
 
 
 
 
PFKEYS: ENTER=COPYTABLE 1=HELP 3=EXIT 12=EXIT

 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved