Kourier Integrator Online Help
KCL.CLEARLOG {APPLICATION| *} FILE.NAME {DATE {TIME}}
This program can be used to clear the Kourier Net Change log for a file. A specific application or all applications may be specified. This command is useful when testing Kourier net change exports or when performing maintenance on the Kourier net change files.
If this command is executed, Net Change for the file specified will be lost. The only recovery is likely a full-refresh of the source data.
|
APPLICATION |
Enter the name of the application or an asterisk (*) to clear all applications where net change has been enabled. Use KCL.LISTLOG to see a list of applications. |
|
FILE.NAME |
Enter the name of the Kourier net change file to process. |
|
DATE |
Optionally a date can be specified (mm-dd-yyyy) which will limit the Net Change log records to be cleared to those were changed on or before the date specified. |
|
TIME |
If a date has be specified, and optional time can also be specified (hh:mm:ss) which will limit the Net Change log records to be cleared to those were changed on or before the date and time specified. |
In this example, the Kourier net change log for the CUSTOMER file is cleared for the application ODS_CUSTOMER.
>KCL.CLEARLOG ODS_CUSTOMER CUSTOMER
Change log cleared for application "ODS_CUSTOMER" in file CUSTOMER.
In this example, the Kourier net change log for the CUSTOMER file is cleared for all applications.
>KCL.CLEARLOG * CUSTOMER
Change log cleared for application "*" in file CUSTOMER.