Data retrival from multiple tables

[santhosh_sontha2]

Hi,

Please let me know how can we access data from mulitple tables in database.

In my scenario i have three tables table1, table2 & table3, please let me know how can we write select query in communication channel.

Regards,

Santhosh

[Former Member]

Hello Santhosh,

If you can not change or create objects in the database (stored proc, view etc), you can write the corresponding / suitable "joined" select statement to retrieve data across the 3 needed tables.

You can ask your db admin to design the best statement (this person will know which index to use etc), and then you just have to use this model to build the same with XI.

Rgds

Chris

[Former Member]

Hi,

To fetch the data from Multiple tables you can create the Storded procedure and then from XI call the stored procedure for retrival of the related fields.

SAP Network Blog: JDBC Stored Procedures

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

stored procedures

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures by siva

jdbc sender(theory)

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

JDBC receiver

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Thanks

Swarup