Proxy to JDBC scenario need dynamic sql query for sender .

[Former Member]

Hi Experts,

I am developing proxy to jdbc scenario. in this i need to pass dynamic sql query  whre we are passing classical method like below.look in classic configuration.

while we are passing select stmt in constant and mapped with access field  and key field mapped with key field.

MY requirement is like instead of passing select stmt in constant where i can generate sql query  dynamically and passed in one field and mapped with access field. find in new requirement image.

What are the steps i need take this Achieve.

Please guide me achieve the requirement .

Regards

Ravinder.s

[Ryan-Crosby]

Hi Ravinder,

A simple UDF or use of graphical mapping functions in most cases should provide you everything you need to construct a dynamic SQL statement for your requirement.

Regards,

Ryan Crosby