IEtlPlainRecordSet.Remove

Syntax

Remove(Value: Integer);

Parameters

Value is a record index.

Description

The Remove method removes a record from data set.

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.Remove(0);

RecordSetOut.Remove(RecordSetOut.Count-1);

End Sub UserSub;

This example is a custom module macro, used to transform data in ETL task. After execution of ETL task, first there are created as many records in a data consumer as there are in a source, then the first and the last record are deleted.

See also:

IEtlPlainRecordSet