Watson Supply Chain Ideas

Use this form to submit an idea for a new product feature. The product team will review your input and provide status updates as decisions are made regarding the request.

Before you submit a new idea, please view requests that have already been submitted. If your idea has already been submitted, you can add comments or vote on the existing idea, thereby indicating your agreement with the idea. We may use this information to help prioritize development of new features.

 

Submit ideas for Watson Marketing and Watson Commerce products

Using dynamic SQL Statement into a map

Hello RFE Community Memebers,

I would like to submit you a request for an enhancement regarding the maps implementation.
Currently, when using SQL Statement in a translation map, it is possible to have static queries only.
It means that we cannot have dynamic queries receiving parameter from the external (from a Business Process, for instance).
I think it would be very useful to have the possibility to write SQL Statements containing dynamic values (something like the question mark we use in the SQL statement in the Lightweight JDBC Adapter).ξ
A sample SQL SELECT could have one of the following format:

select COL1, COL2, COL3 from MY_TABLE where COL4=? and COL5=?

where the dynamic parameter could correspond toξ

Param1: '/ProcessData/Val1/text()' ξ ξ(XPath format)
Param2: '/ProcessData/Val2/text()' ξ ξ(XPath format)

This modification would improve the usage of maps and it would make them fully integrated with the Business Process environment.

Thanks for your job!

Best regards
Alberto Rodino
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Dec 19 2017
  • Uncommitted Candidate
How will this idea be used?
What is your industry?
What is the idea priority? Medium
DeveloperWorks ID DW_ID39688
RTC ID RTC_ID398701
Link to original RFE http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=39688
  • Attach files