IEtlPlainRecordSet.Clear

Syntax

Clear;

Description

The Clear method clears flat records set added as a result of custom algorithm execution.

Example

Sub UserSub(Input: IEtlPlainRecordSets; Output: IEtlPlainRecordSets);

Var

RecordSetIn, RecordSetOut: IEtlPlainRecordSet;

i: Integer;

Begin

RecordSetIn:=Input.Item(0);

RecordSetOut:=Output.Item(0);

For i := 0 To RecordSetIn.Count - 1 Do

RecordSetOut.Add;

RecordSetOut.Item(i).Value(0):=RecordSetIn.Item(i).Value(0);

End For;

RecordSetOut.Clear;

End Sub UserSub;

This example is a custom unit macro that is used to transform data in ETL task. After executing the ETL task, first, the equal number of records is created in a data consumer as welll as in a data source, then all added records will be deleted.