JDBC-XI-File Scenario

[Former Member]

Dear All,

I want to take data from multiple database tables & want a file at the output. So, can I write the JOIN statement along with the SELECT statement at the sender adapter, bcoz if we write JOIN then the statement will be very long there. Plz guide me of the best way to this scenario.

reg,

nishu

[Former Member]

Hi Nishu,

You can use a SENDER JDBC adapter for your case.

This is how a SENDER JDBC Adapter works,

When you are using your JDBC as a sender, then your JDBC will poll over your database and select the rows that satisfy your Select Query.

In your case, as you are dealing with multiple tables, you can write a stored proceudre for your Database, and call this stored procedure in your Sender JDBC adapter in the SELECT field of your JDBC adapter.

Go through this blog for stored procedures.

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

To access any Database from XI, you will have to install the corresponding Driver on your XI server.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

I hope this helps...

Regards,

Abhy

[sridharreddy_kondam]

Hi Nishu,

Yes it is possible by using joins

Try this

select table1.empid,table1.empname,table2.project from table1,table2 where table1.empid=table2.empid where condition.

Regards,

Sridhar

[Former Member]

Nishu,

You can write a long SQL select statement. I have encountered a similar scenario where I needed to pick data from 2 able each containing 10 fields. I have written a very long sql statement and it works with out a problem.

Regards,

Jai Shankar.

[Former Member]

Hi ,

Yes..you have to write the join query when you want to select data from mulipltle tables...

see this thread...

Thanks,

sekhar