DMXSetSourceSqlText function - Connect_ETL - 9.13

Connect ETL Shell Functions 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 Shell Functions Reference
Copyright
2023
First publish date
2003
Last updated
2023-09-11
Published on
2023-09-11T19:06:59.560515

Short Description: To replace the SQL text associated with a source.

Syntax

DMXSetSourceSqlText ID sqlText [sqlTextNumber]

Parameters

ID The ID returned by DMXNew that identifies the invocation.
sqlText A string with the replacement.
sqlTextNumber An integer with the number of the source SQL text you want to change. The sources are numbered sequentially from 1 in the order in which they appear in the application file identified by the applicationFileName parameter for DMXSetApplicationFileName. The parameter is optional and defaults to 1.

Notes

You can invoke this function at any time after loading the application via DMXSetApplicationFileName and before running the application via DMXRun.