Dynamic where condition in select query for JDBC Adapter

[former_member225737]

Hi Experts,

     I had a scenario in which I want to change WHERE condition in SELECT query for JDBC Adapter change dynamically.

Thanks,

Parin Chahwala.

[Former Member]

Dear  Parin,

Please  check the below link for  the standard structure for JDBC (XML Document Format for the Message Protocol XML SQL Format😞

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

.....

Mutti .

[Former Member]

Please see if there is a possibility of using a stored procedure on DB side to handle dynamic query , IMO it might create in consistency  to write update statement for the select.

[former_member184720]

Please provide more details.. Dynamic date? dynamic value for any column?

You can use JDBC lookup.

trigger file(File) -> Mapping(JDBC Lookup) -> Target system

Else you can configure JDBC receiver adapter for select query (Sync interface)

[former_member225737]

Dynamic column in where condition.

[Former Member]

Hi

Check this

Thanks,

Indrajit

[former_member184720]

Your table structure is static right?
Configure the possible columns as Key segments in your target structure.

You can even try the SQL_DML type structure(type6) JDBC sql format.

Document Formats for the Receiver JDBC Adapter - SAP NetWeaver Exchange Infrastructure - SAP Library