Joins statements in JDBC Receiver

yes you can.

More details follow up with this thread - jdbc---table-join

Yes you can join tables (2 or more than 2 also) in JDBC receiver channel.

Thanks,

Hetal

Hi,

you can do it without joins also using Stored Procedures(SP)

1) Create temporary table inside the SP which has all the fields.

2) Insert the data into temp table from multiple tables by executing the joins which u have created.

3) After inserting all the records just execute a select * on that temporary table which is the final o/p.

4) Drop temporary table.

Hope this will help you.

jabbs:)

Ria,

This can be done using a standard way...

i will give u the complete solution..

create the target data type as

MT (This is request message type)

+Statement1

++anyname

++access

++key

+++field1

In Action : pass constant SQL_Query.

in acess : pahe following query

SELECT U1.PEID ,U1.PECOMP ,U1.PEVEND ,U1.PEBANK ,U2.PISUB ,U2.PICURR ,U2.PIINVN ,U2.PIIDTE FROM UAPE U1, UAPI U2 WHERE (U1.PECOMP = U2.PICOMP)

AND U1.PETREF = '$field1$'

see the $ sign here so taht wahtever value that goes into field1 will be passed to this select query

you also have to create appropriate response structure so that you can captures the rows sent by the database

MT_response (...note that MT here is the same name as we used above followed by _responswe)

+Statement1_response

++row

+++field1(fields which would be returned by the above query

+++field2

also create a inbound sync MI with request message type as MT and reponse as MT_response

now suppose your sender was RFC synchronous then you cna mapp this MT_response with the RFC response and specify this response mapping in the "response" tab of the interface mapping

Giving points is another way to say thanks