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

DMExpressLibraryVersion property

<DMExpress Class>.DMExpressLibraryVersion

Property definition

Type Access Description
String expression Read The version of the DMExpress library.

EstimatedInputDataBytes property

<DMExpress Class>.EstimatedInputDataBytes

Property definition

Type Access Description
Double float expression Write The total size in bytes of source records you estimate will be released to the DMExpress task, after any filtering for all targets. The expression must have an integral value of 1 or greater. Assigning any other value generates an error.

Notes

You can change this property at any time before running the task via Run.

You can set this property only for an aggregate, copy, merge or sort. For a join, set the property EstimatedJoinSideDataBytes.

EstimatedInputRecordCount property

<DMExpress Class>.EstimatedInputRecordCount

Type Access Description
Double float expression Write The number of source records you estimate will be released to the DMExpress task, after any filtering for all targets. The expression must have an integral value of 1 or greater. Assigning any other value generates an error.

Notes

You can change this property at any time before running the task via Run.

You can set this property only for an aggregate, copy, merge or sort. For a join, set the property EstimatedJoinSideRecordCount.

EstimatedJoinSideDataBytes property

<DMExpress Class>.EstimatedJoinSideDataBytes (side)

Property definition

Type Access Description
Double float expression Write Estimate of the total size in bytes of source data from the specified join side, after any filtering for all targets. The expression must have an integral value of 1 or greater. Assigning any other value generates an error.

Parameters

Name Type Description
side integer expression. The side of the join for which you are providing the estimate. The left side is 1 and the right side is 2.

Notes

You can set this property only for a join. For other types of task, set the EstimatedInputDataBytes property.

EstimatedJoinSideRecordCount property

<DMExpress Class>.EstimatedJoinSideRecordCount (side)

Property definition

Type Access Description
Double float expression Write Estimate of the number of source records from the specified join side, after any filtering for all targets. The expression must have an integral value of 1 or greater. Assigning any other value generates an error.

Parameters

Name Type Description
side integer expression. The side of the join for which you are providing the estimate. The left side is 1 and the right side is 2.

Notes

You can set this property only for a join. For other types of task, set the EstimatedInputRecordCount property.

HighestSeverityRecorded property

<DMExpress Class>.HighestSeverityRecorded

Property definition

Type Access Description
Integer expression Read

The highest severity of exceptions recorded during the DMExpress run.

  • 0 - success. No exceptions encountered so far
  • 1 - warning. Minor exceptions encountered
  • 2 - severe. The target produced by DMExpress may be incorrect or incomplete

LogFileName property

<DMExpress Class>.LogFileName

Property definition

Type Access Description
String expression Read/write The name of the log file that receives messages generated during a DMExpress run.

Notes

You can change this property at any time before running the task via Run.

OutOfOrderRecordDetected property

<DMExpress Class>.OutOfOrderRecordDetected

Property definition

Type Access Description
Boolean expression Read

A flag indicating if DMExpress detected any out-of-order records, when you request sequence checking in the task.

  • False - DMExpress did not detect an out-of-order record
  • True - DMExpress detected an out-of-order record

Notes

This property always returns False when you do not request sequence checking in the DMExpress task.

Statistics property

<DMExpress Class>.Statistics

Property definition

Type Access Description
IDMExpressStatistics interface Read The statistics of the DMExpress run.

TaskFileName property

<DMExpress Class>.TaskFileName

Property definition

Type Access Description
String expression Read/write The name of the DMExpress task (.dxt) file containing the task to be run.

Notes

You can change this property at any time before running the task via Run.