Skip to Content
avatar image
Former Member

Proxy to JDBC scenario need dynamic sql query for sender .

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 30, 2014 at 05:07 PM

    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

    Add comment
    10|10000 characters needed characters exceeded