KCL.MOVELOG
Syntax
KCL.MOVELOG APPLICATIONS SRC.FILE.NAME TO TRG.FILE.NAME {CONV “CONVERSION”}
Description
This program can be used to move the net change log records associated with an application in the source file to the net change log records of the target file. This command is useful when creating an export that pulls data from more than one file and that export has been configured to run in net change mode.
Caution
The item-ids of the source file must match the item-ids in the target file OR after applying a conversion to a source file item-id, the resulting item-id matches the item-ids in the target file.
Options
|
APPLICATION |
Enter the name of the application. For most scenarios that use the KCL.MOVELOG command, you will have used the KCL.ADDLOG command to setup net change on the source file for the application. |
|
SRC.FILE.NAME |
Enter the source file name. |
|
TRG.FILE.NAME |
Enter the target file name. |
|
CONVERSION |
Enter any valid dictionary conversion code. The conversion will be applied to the item-id of the source file and the result of the conversion will be used as the item-id of the target file. |
Usage Example
In this example, assume that:
- A file named CUSTOMER stores the standard fields associated with a customer.
- A file named CUSTOMER_CUSTOM stores custom fields specific to the implementation of your application.
- Both files share the same item-id (e.g. Customer Number).
- A net change enabled export has been created that pulls data from both the CUSTOMER file, which is the Export Data File in the export and the CUSTOMER_CUSTOM file.
- The KCL.ADDLOG command has been used to create an application called XFER_CUSTOMER on the CUSTOMER_CUSTOM file.
>KCL.MOVELOG XFER_CUSTOMER CUSTOMER_CUSTOM TO CUSTOMER
Change log for application "XFER_CUSTOMER" on file CUSTOMER-CUSTOM has been move to file CUSTOMER. 100 records moved.