very urgent (using join conditions in PI)

31 Views

Hi PI gurus.

My scenario is SOAP to JDBC(Portal Webdynpro screen to Oracle database).

I have a requirement to fetch some complex data from the database using complex nested queries.How can i go ahead using join conditions in PI.Here the client is insisiting only on queries and rejected all other methods for solving this like

1)Java proxies

2)stored procedures written in the database system

3)Create a logical view in database system .

The following option is permitted for me by the client to follow

· Using the SQL_QUERY as a query method in the JDBC Receiver Channel in XI

· Trying out JOIN conditions to make multiple query into a single query:- Here need to check the feasibility of the JOIN Condition

Please help me to complete our task.

points will be rewarded for helpful answers.

Thanks & Regards

Veena