Sender JDBC

[Former Member]

Hi all,

My Senario is JDBC to file.

How do i configure a sender JDBC Channel

Please tell me the structure of the sending channel and help me out with blogs

Rgds

Aditya

[Former Member]

Thnks all the matter is solved

Rgds

Aditya

[prateek]

I think u should mark each helpful ans

[Former Member]

Thnks all

It works i would like to know if i can Query two tables at the same time

Is it possible

Rgds

Aditya

[prateek]

Make use of joins in the query

e.g. SELECT <Table_2>.EID, <Table_2>.FName, <Table_2>.LName, <Table_1>.REC_DAT, <Table_1>.DESCRP

FROM <Table_1> INNER JOIN <Table_2> on

<Table_1>.CARDNO = <Table_2>.CARD

where REC_DAT = <condition>

union

SELECT <Table_2>.EID, <Table_2>.FName, <Table_2>.LName, <Table_1>.REC_DAT, <Table_1>.DESCRP

FROM <Table_1> INNER JOIN <Table_2> on

<Table_1>.CARDNO = <Table_2>.CARD

where REC_DAT = <condition>

Regards,

Prateek

[Former Member]

hi Prateek

Is it not possible to do it with two select query

Rgs

Aditya

[prateek]

JDBC sender adapter allows u to enter only one select query.

If u use 2 channels then it would become N:1 scenario which I am sure u dont want

And why to complicate the matter when it could be achieved easily

Regards,

Prateek

[Former Member]

Hey check these

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm">sender jdbc adapter</a>

tutorial <a href="/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter:///people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

Cheers,

<b>RAJ

*REWARD POINTS IF FOUND USEFULL*</b>

[former_member192892]

Hi adi,

Use thes step by step guidese

https://wiki.sdn.sap.com/wiki/display/XI/JDBCTOJDBC

https://wiki.sdn.sap.com/wiki/display/XI/XMLFile2XMLFile

You need to just configure the first wiki step by step to JDBC to File...

If should be easy...

Varun

[Former Member]

The data type structure for the same will be

row

field 1

field2

.....

JDBC Receiver Adapter -- Synchronous Select – Step by Step

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

Mudit