Properties - Connect_ETL - 9.13

Connect ETL ActiveX Reference

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect (ETL, Sort, AppMod, Big Data)
Version
9.13
Language
English
Product name
Connect ETL
Title
Connect ETL ActiveX Reference
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-11
ft:lastPublication
2023-09-11T18:59:22.799064

DeletedInputRecordCount property

<DMExpressStatistics Class>.DeletedInputRecordCount

Property definition

Type Access Description
Double float expression Read The number of source records deleted because of data errors.

DeletedOutputRecordCount property

<DMExpressStatistics Class>.DeletedOutputRecordCount [(index)]

Property definition

Type Access Description
Double float expression Read The number of records intended for a target but deleted because of data errors.

Parameters

Name Type Description
index Integer expression. Optional, default is 1. The number of the target file in the DMExpress task; target files are numbered from 1 in the order in which they appear in the task. You can obtain the maximum value of the index (the number of target files) from the TargetCount property. An index outside the valid range generates an error.

InputDataBytes property

<DMExpressStatistics Class>.InputDataBytes

Property definition

Type Access Description
Double float expression Read The total size in bytes of source records.

InputRecordCount property

<DMExpressStatistics Class>.InputRecordCount

Property definition

Type Access Description
Double float expression Read The number of source records.

JoinSideCount property

<DMExpressStatistics Class>.JoinSideCount

Property definition

Type Access Description
Long integer expression Read The number of join sides. 0 is returned for an aggregate, copy, merge or sort.

JoinSideDataBytes property

<DMExpressStatistics Class>.JoinSideDataBytes (side)

Property definition

Type Access Description
Double float expression Read The total size in bytes of source records for one side of the join.

Parameters

Name Type Description
side Integer expression The side of the join for which you want the statistic. The sides are numbered from 1 to the maximum available from the JoinSideCount property (currently 2). A side outside the valid range generates an error.

JoinSideDeletedRecordCount property

<DMExpressStatistics Class>.JoinSideDeletedRecordCount (side)

Property definition

Type Access Description
Double float expression Read The number of source records from one side of the join that were deleted because of data errors.

Parameters

Name Type Description
side Integer expression The side of the join for which you want the statistic. The sides are numbered from 1 to the maximum available from the JoinSideCount property (currently 2). A side outside the valid range generates an error.

JoinSideMaxRecordLength property

<DMExpressStatistics Class>.JoinSideMaxRecordLength (side)

Property definition

Type Access Description
Long integer expression Read The length in bytes of the longest source record from one side of the join.

Parameters

Name Type Description
side Integer expression The side of the join for which you want the statistic. The sides are numbered from 1 to the maximum available from the JoinSideCount property (currently 2). A side outside the valid range generates an error.

JoinSidePairedDataBytes property

<DMExpressStatistics Class>.JoinSidePairedDataBytes (side)

Property definition

Type Access Description
Double float expression Read The total size in bytes of source records for one side of the join that were paired.

Parameters

Name Type Description
side Integer expression The side of the join for which you want the statistic. The sides are numbered from 1 to the maximum available from the JoinSideCount property (currently 2). A side outside the valid range generates an error.

JoinSidePairedRecordCount property

<DMExpressStatistics Class>.JoinSidePairedRecordCount (side)

Property definition

Type Access Description
Double float expression Read The number of source records from one side of the join that were paired.

Parameters

Name Type Description
side Integer expression The side of the join for which you want the statistic. The sides are numbered from 1 to the maximum available from the JoinSideCount property (currently 2). A side outside the valid range generates an error.

JoinSideRecordCount property

<DMExpressStatistics Class>.JoinSideRecordCount (side)

Property definition

Type Access Description
Double float expression Read The number of source records from one side of the join.

Parameters

Name Type Description
side Integer expression The side of the join for which you want the statistic. The sides are numbered from 1 to the maximum available from the JoinSideCount property (currently 2). A side outside the valid range generates an error.

JoinSideUnpairedDataBytes property

<DMExpressStatistics Class>.JoinSideUnpairedDataBytes (side)

Property definition

Type Access Description
Double float expression Read The total size in bytes of the source records that were not paired from one side of the join.

Parameters

Name Type Description
side Integer expression The side of the join for which you want the statistic. The sides are numbered from 1 to the maximum available from the JoinSideCount property (currently 2). A side outside the valid range generates an error.

JoinSideUnpairedRecordCount property

<DMExpressStatistics Class>.JoinSideUnpairedRecordCount (side)

Property definition

Type Access Description
Double float expression Read The number of source records from one side of the join that were not paired.

Parameters

Name Type Description
side Integer expression The side of the join for which you want the statistic. The sides are numbered from 1 to the maximum available from the JoinSideCount property (currently 2). A side outside the valid range generates an error.

MaxInputRecordLength property

<DMExpressStatistics Class>.MaxInputRecordLength

Property definition

Type Access Description
Long integer expression Read The length in bytes of the longest source record.

MaxOutputRecordLength property

<DMExpressStatistics Class>.MaxOutputRecordLength [(index)]

Property definition

Type Access Description
Long integer expression Read The length in bytes of the longest record sent to a target.

Parameters

Name Type Description
index Integer expression Optional, default is 1. The number of the target file in the DMExpress task; target files are numbered from 1 in the order in which they appear in the task. You can obtain the maximum value of the index (the number of target files) from the TargetCount property. An index outside the valid range generates an error.

MaxProcessedRecordLength property

<DMExpressStatistics Class>.MaxProcessedRecordLength

Property definition

Type Access Description
Long integer expression Read The length in bytes of the longest record aggregated, copied, merged or sorted.

OutputDataBytes property

<DMExpressStatistics Class>.OutputDataBytes [(index)]

Property definition

Type Access Description
Double float expression Read The total size in bytes of records sent to a target.

Parameters

Name Type Description
index Integer expression Optional, default is 1. The number of the target file in the DMExpress task; target files are numbered from 1 in the order in which they appear in the task. You can obtain the maximum value of the index (the number of target files) from the TargetCount property. An index outside the valid range generates an error.

OutputRecordCount property

<DMExpressStatistics Class>.OutputRecordCount [(index)]

Property definition

Type Access Description
Double float expression Read The number of records sent to a target.

Parameters

Name Type Description
index Integer expression Optional, default is 1. The number of the target file in the DMExpress task; target files are numbered from 1 in the order in which they appear in the task. You can obtain the maximum value of the index (the number of target files) from the TargetCount property. An index outside the valid range generates an error.

ProcessedDataBytes property

<DMExpressStatistics Class>.ProcessedDataBytes

Property definition

Type Access Description
Double float expression Read The total size in bytes of aggregated, copied, merged or sorted records.

ProcessedRecordCount property

<DMExpressStatistics Class>.ProcessedRecordCount

Property definition

Type Access Description
Double float expression Read The number of aggregated, copied, merged or sorted records.

TargetCount property

<DMExpressStatistics Class>.TargetCount

Property definition

Type Access Description
Long integer expression Read The number of targets to which DMExpress sends output records.

UsedWorkspaceBytes property

<DMExpressStatistics Class>.UsedWorkspaceBytes

Property definition

Type Access Description
Double float expression Read The size in bytes of disk space allocated for temporary work files.