Open topic with navigation

Kourier Integrator Online Help

KCL.REMOVEINDEX

Syntax

KCL.REMOVEINDEX {FILENAME} | ALL | *

Description

This command is used to remove the Kourier Integrator Net Change index associated with a U2 file.

Under normal circumstances, it is not necessary to use this command for Kourier Integrator exports. You should use the Enable Net Change setting, which is available on the Export Specifications page.

However, for some U2 software applications it is a common practice to create a "snap-shot" copy of a U2 application file at specific intervals (e.g.,  at month-end or year-end) by copying the U2 application file at the Operating System level (i.e., at UNIX or Windows). When this technique is utilized, all RDBMS indexes associated with the U2 file are copied--including the Kourier Integrator Net Change index called KCL_INDEX. This can cause problems because the KCL_INDEX dictionary contains an absolute path to the U2 file where Kourier Integrator Net Change was enabled. In order to prevent the Net Change log file of the original U2 file from being updated if records are modified in the copied U2 file, this index should be removed using the KCL.REMOVEINDEX command on the copied U2 file.

Caution

Under normal circumstances, it is not necessary to use this command from TCL unless you have copied a file at the Operating System level. For Kourier Integrator exports, Net Change is automatically managed directly from the graphical user interface. 

Improper use of this command may cause your Kourier Integrator exports to become non-operational. If you are unsure of how to use this command or the potential impact on your system, please call Kore Technologies technical support. 

Options 

FILE.NAME

Enter the name of the file which has a Kourier Integrator Net Change index to be removed.

ALL

Use this option to remove all Kourier Integrator Net Change indexes from the file.

Usage Examples

ClosedExample 1 - Kourier Net Change Index is Removed

In this example, the Kourier Integrator Net Change index is removed from a file called CUSTOMER-2008 which was copied from the CUSTOMER file at year-end.  The Kourier Integrator Net Change index for the CUSTOMER file is unaffected.

>>KCL.REMOVEINDEX CUSTOMER-2008
Removed the Kourier net change index from file CUSTOMER-2008.
ClosedExample 2 - Kourier Net Change Index Does Not Exist

In this example, the Kourier Integrator Net Change index for the CUSTOMER does not exist.

>KCL.REMOVEINDEX CUSTOMER-2008
File CUSTOMER-2008 does not have a Kourier net change index.

Related Topics: 

Kourier TCL Commands Overview

KCL.LISTLOG