IEtlObject.Remove

Fore syntax

Remove;

Fore.NET syntax

Remove();

Description

The Remove method removes ETL task object.

Comments

Any ETL task object has two linked components:

The IEtlObject object.
The IWxShape visual view.

To remove a ETL task object first of all remove its visual view.

Fore example

Executing the example requires the repository contains an ETL task with the ETL_TASK identifier containing at least one object.

Add links to the Andy, Etl, Metabase system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    MbObj: IMetabaseObject;
    EtlTask: IEtlTask;
    Shape: IWxShape;
    EtlObj: IEtlObject;
Begin
    MB := MetabaseClass.Active;
    MbObj := MB.ItemById("ETL_TASK").Edit;
    EtlTask := MbObj As IEtlTask;
    Shape := EtlTask.Workspace.Shapes.Item(0);
    Shape.Delete;
    EtlObj := EtlTask.Item(0);
    EtlObj.Remove;
    MbObj.Save;
End Sub UserProc;

Executing the example removes an ETL task object with the 0 index.

Fore.NET example

The requirements and result of the Fore.NET example execution match with those in the Fore example.

Imports Prognoz.Platform.Interop.Andy;
Imports Prognoz.Platform.Interop.Etl;
…
Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    MbObj: IMetabaseObject;
    EtlTask: IEtlTask;
    Shape: IWxShape;
    EtlObj: IEtlObject;
Begin
    MB := Params.Metabase;
    MbObj := MB.ItemById["ETL_TASK"].Edit();
    EtlTask := MbObj As IEtlTask;
    Shape := EtlTask.Workspace.Shapes.Item[0];
    Shape.Delete();
    EtlObj := EtlTask.Item[0];
    EtlObj.Remove();
    MbObj.Save();
End Sub;