Originally posted by: SystemAdmin

Windows Server 2003, SP2
WTX 8.2.0.3

Is placing a resource alias in the command line of a database adapter output card in the Launcher Settings of the IFD supposed to work? Should not the alias be resolved by the Launcher and override any similar settings in the map source? It doesn't work for me.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Or, should the following map rule resolve the %DB_Trace% resource alias when executing my map from the Design Studio? It executes fine if I delete the resource alias but fails with it:

=VALID( DBQUERY(
"{call usp_EAI_Insert_New_Batch('ADP', 'Mercator', '1')}", 
" -MDQ XML_StoredProcs.mdq -DBNAME APS %DB_Trace%" ), FAIL( 
"Get BatchID Call Failed"))

where %DB_Trace% =
<Value Server="Local Server" encrypt="OFF">-T+</Value>

I've defined Window-->Preferences-->Transformation Extender-->Map-->Run Options: Configuration File=C:\IBM\WebSphere Transformation Extender 8.2\resource.mrc and the resource.mrc file contains the following:

<?xml version=
"1.0" encoding=
"UTF-8"?> <ResourceCfg> <EventServer/> <CommandServer> <ResourceFile ActiveVirtualServer=
"Local Server"> C:\IBM\WebSphere Transformation Extender 8.2\Resource\XML.mrn </ResourceFile> </CommandServer> <Global> <ResourceFile ActiveVirtualServer=
"Local Server"> C:\IBM\WebSphere Transformation Extender 8.2\Resource\XML.mrn </ResourceFile> </Global> </ResourceCfg>

#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender