Query regarding JDBC adapter

[Former Member]

Hi All,

Can we have two resultset in receiver jdbc adapter for a single query sent through sender jdbc adapter????

Regards

Madhu

[Former Member]

HI,

Can you please clear your requirement?

Plz see the below links

JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

Receiver JDBC scenario - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

Regards

Chilla

[bhavesh_kantilal]

Can you give an example of what you are attempting?

As far as I know your Select Query is going to return a set of rows satisfying your where clause and you can use Join Statements in this Select Query.

Also you can use Alias Names in the Select query to rename the column names confirming to your datatypes created.

Regards

Bhavesh