KCL.CLEARCHECKSUM

Kourier Integrator Online Help

KCL.CLEARCHECKSUM

Description

This program can be used to clear the checksum information for a specific application. This command is useful because Kourier does not automatically clear this information when checksum feature is disabled for an application.

Syntax for U2

KCL.CLEARCHECKSUM APPLICATION FILE.NAME {DATE {TIME}} {(O}

Options for U2 Files

APPLICATION	Enter the name of the application. This is normally the name of the export where net change with checksum has been enabled.
FILE NAME	Enter the name of the Kourier checksum file to process.
DATE	Optionally a date can be specified (mm-dd-yyyy) which will limit the checksum 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 checksum records to be cleared to those were changed on or before the date and time specified.
(O	This option can be used to disable the commands normal behavior of verifying that the application is properly registered in the checksum control table before removing the checksum information.

Syntax for ODBC Tables

KCL.CLEARCHECKSUM ODBC EXPORT.NAME TABLE.NAME {DATE {TIME}} {(O}

Options for ODBC Tables

ODBC	This should always be the literal string ODBC
EXPORT.NAME	Enter the name of the export where net change with checksum has been enabled.
TABLE.NAME	Enter the name of the source ODBC table.
DATE	Optionally a date can be specified (mm-dd-yyyy) which will limit the checksum 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 checksum records to be cleared to those were changed on or before the date and time specified.
(O	This option can be used to disable the commands normal behavior of verifying that the application is properly registered in the checksum control table before removing the checksum information.

Example 1

In this example, we will remove the checksum information on and ODBC export named QSQL_CUSTOMER_NETCS for an source table of CUSTOMER.

>KCL.CLEARCHECKSUM ODBC QSQL_CUSTOMER_NETCS CUSTOMER

Cleared 55 of 55 checksum log records for application "CUSTOMER" on file

QSQL_CUSTOMER.NETCS in 0.000 seconds.

Example 2

In this example, we will remove the checksum information on an U2 to SQL export named TSQL_CUSTOMER for the file CUSTOMER.

>KCL.CLEARCHECKSUM TSQL_CUSTOMER CUSTOMER

Cleared 54 of 54 checksum log records for application "TSQL_CUSTOMER" on file

CUSTOMER in 0.015 seconds.