Data types for Sender/receiver JDBC

[Former Member]

HI experts,

I am very much confused how the data types shoudl be for the Sender/receiver for JDBC.

And is there any standard format where it should be used, or what is the strucutre to be used,.

Please let me know in clear and help me out in this regard,

[Former Member]

HI Amruth

Whats your requirement. Giving example specific to requirement is better option to solve. Else you will get lots of links and blog.

Moreover dont create catch with points. Moderator will remove such statements and can even lock the thread.

Thanks

Gaurav

[dharamveer_gaur2]

hi

Look these blog

https://www.sdn.sap.com/irj/scn/wiki?path=/display/xi/jdbc%252bto%252bjdbc

[Former Member]

Hi Amruth

Did you checked with SAP Help or SDN

There are the standard

Sender

http://help.sap.com/saphelp_nw04s/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

Receiver document format

http://help.sap.com/saphelp_nw04s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Thanks

Gaurav

[Former Member]

Hi,

Could you please explain me in with your own example please.,

It will fetch me a lot

Please help me with your example

Full point will be awarded if you can help me in this regard

[former_member200962]

Hi,

Refer this blog for receiver JDBC structure....the table and action elements mentioned in this blog are normally mapped to constants....

table is mapped to the actual table name of DB....action is insert/update/delete etc as per your need.......rest of the structure may not be same...you need to check how is the data stored in your DB (names/columns etc) before you make a structure in XI for the same.

Regards,

Abhishek.

[Former Member]

refer these blogs for better informations on jdbc data types

https://www.sdn.sap.com/irj/scn/wiki?path=/display/xi/file%252bto%252bjdbc

https://www.sdn.sap.com/irj/scn/wiki?path=/display/xi/jdbc%252b2%252bjdbc (for reciever JDBC)