Using IN statement in PI JDBC Adapter

[former_member191528]

Hello All,

We are trying to execute a SOAP - PI - JDBC scenario where we are pulling data from backend database. We wanted to enhance an existing SQL query structure in PI with IN statement (hence not using stored procedure option). Can you please direct me to blogs/ wiki's for using IN statement in SQL query ?

Thanks,

Kiran

[MichalKrawczyk · Accepted solution]

Hi,

>>>We wanted to enhance an existing SQL query structure in PI with IN statement

you can try using:

action= SQL_QUERY | SQL_DML

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

Regards,

Michal Krawczyk

[former_member191528 · Accepted solution]

Thanks Michal !! This is exactly what we were looking for. Truly appreciate your help.

[baskar_gopalakrishnan2]

Best place to understand with clarity...

http://www.w3schools.com/sql/sql_in.asp

Usage IN statement is simple and the above link will help for various clause, join, IN statement etc... If you have still problem provide us your query here..

Hope that helps.