Originally posted by: SriniBodapati

Hi All,

I have created mdq file and sql query type tree using Database Interface designer. The sql query has one variable in WHERE clause.

I have to fetch value for this variable from Sterling ProcessData and set it as run time parameter to WTX sql query input card.

SQL Type Tree Query:

-----------------

SELECT * FROM ACCOUNT WHERE ENTITYID = #EntityID#

In input card tree, I am setting GET->Source -> Command to "-ID -VAR EntityID='026'". This is working fine.

Please suggest how to get the value '026' from Sterling B2B process data and pass it to the command.

Thanks,

Srinivas

Originally posted by: SriniBodapati

Hi All,

Any help in this regard.

Got one reference link in community forum 

https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000013937559

As per my understanding from above link, created 1 input card that reads variable from Sterling Process Data. Below is the command

=GET("Sterling", "-t+ -c getProcessData -k EntityID")

The 2 input card is DBSelect query without any variables.

Assigned input card 1 output to an output card which has item field that writes to a file.

I have second output card which executes a RUN command with overwrite parameters.

=VALID(RUN("AccFeedIn.mmc","-ID -MDQ Database_AccFeed_Dynamic_Query.mdq -DBNAME Local-SQL -QUERY AccFeedParameterizedQuery -TRACE -VAR EntityID="+B2BPD),FAIL(""))

Map is compiled successfully, however I am getting an exception in run time.

FAIL:function aborted map

Please help.

Thanks,

Srinivas