KCL.CLEARLOG

Syntax

KCL.CLEARLOG {application | *} file.name {date {time}}

Description

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.

Caution: 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.

Options

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.

Usage Examples

Example 1
Example 2

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.