JDBC as receiver scenario

[Former Member]

HI,

Can anybody please explain me how to define the receiver datatype if the JDBC is used at the receiver side with some explanation.

I could see some examples...and they have created in the following way

Data_type

___________Statement

_____________Action

____________Table Name

|__________fieldname

My question is why do we need to have this "statement" element definied? and cant we use another word instead of "statemnet".

Priya

[moorthy]

Hi Priya,

This blog also give some valuable inputs-

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

Rgds,

moorthy

[Former Member]

Priya,

As mentioned in the blog: /people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 you can use the same or if you want to use a different name also you can use it. But you have to hardcode a constant for action because here you are mentioning what you are going to do with the database. So you can give the value as INSERT, UPDATE etc. Table Name specifies the table on which you are performing the operations. Make sure that you have the table created in the database before you perform this operation.

Hope this clears your doubts......

---Satish

[agasthuri_doss]

Hi,

I hope this might help you

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Regards

Agasthuri Doss

[Former Member]

Hi Priya,

you have to specify a data type for XML SQL Format.

The following document can help you:

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/676b3c255b1475e10000000a114084/frameset.htm

<a href="/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 to JDBC Adapter using SAP XI 3.0</a>

Hope this help