KCL.CLEARLOG

Syntax

KCL.CLEARLOG {application | *} file.name

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.

Example 1

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.

Example 2

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.


User Guide - Table of Contents