sqlExecOnDataSource

            sqlExecOnDataSource
      (query, dataSource [, value1, ... ])
         

The authorized values for the data source can be:

• "" or "default" points to the Adobe Campaign database
• "nms:extAccount:InternalName" points to a datasource defined in the Adobe Campaign external accounts (FDA)
• "name" (name of the datasource) points to a data source defined in the instance configuration file (config-instance.xml) in the following form:

  
                   <dataStore hosts="*" lang="">
        <dataSource name="datasourcename">
          <dbcnx encrypted="" login="" password=""
                 provider="" server=""/>
        </dataSource>
      </dataStore>

Example:

sqlExecOnDataSource("UPDATE XtkOption SET sStringValue = $(sz) WHERE sName = $(sz)", oracleExternalDB, 'WdbcOptions_TableSpaceWork_nms:extAccount:' + sExtAccount)

The optional variables set as parameters of this function are defined in sqlGetString(query, value1, ...)