Kourier Integrator Online Help
KCL.MAKEBATCH SOURCE_FILE {CRITERIA} {BATCH-SIZE nnnn}
This program can be used with net change to perform a full refresh on files.
|
SOURCE_FILE |
The source file where net change has been setup. |
|
CRITERIA |
Enter the selection criteria to limit the records that will be added to the net change log. |
|
BATCH-SIZE |
an optional keyword and value that can be used to control the size of a batch. By default a value of 20,000 is used |
In this example, KCL.MAKEBATCH command is being used to select all records from the original cut-off date of 06-20-2010 thru the temporary cut-off date of 01-01-2015.
You must include any other criteria that you are using in your parent export (e.g. AND WITH @ID = “S]”) when running the KCL.MAKEBATCH command.
KCL.MAKEBATCH LEDGER WITH DATE >= “6-20-2010” AND WITH DATE < “01-01-2018” BY-DSND DATE
13:09:08 13 APR 2017 Selecting Records...
13:09:08 13 APR 2017 Executing: KSSELECT LEDGER DATE >= “6-20-2010” AND WITH DATE < “01-01-2018” BY-DSND DATE
13:09:08 13 APR 2017 Result: Result= 59216 record(s) selected to SELECT list #0.
13:09:08 13 APR 2017 Building Batches...
13:09:08 13 APR 2017 Saving Batch KEBATCH_LEDGER_00001
13:09:08 13 APR 2017 Saving Batch KEBATCH_LEDGER_00002
13:09:08 13 APR 2017 Saving Batch KEBATCH_LEDGER_00003
13:09:08 13 APR 2017 Removing OLD Batches...
13:09:08 13 APR 2017 Executing: KT.DELETE KT_IOTEMP WITH @ID > "KEBATCH_LEDGER_00003" AND WITH @ID = "KEBATCH_LEDGER_]"
13:09:08 13 APR 2017 Results: Items Read: 0 Items Deleted: 0 Items Locked: 0
Added 59216 records to 3 batches for file LEDGER.
>