Anybody know how to connect to DB2 not use JDBC by SAP PI(XI)?

[JohnPark]

We will try connect to DB2 7.x.

but DB2 is support JDBC type 2 and type 3. not support type 4.

so we think that use DB2 Connect support by IBM.

It's not good for Customer. so I want connect using tech-knowldge SAP PI.

How can I do?

[Former Member · Accepted solution]

Hi !

I think you can connect to DB2 Connect from XI using JDBC Type 4 and then DB2 Connec will connect to DB2 7.x using 2 or 3.

Other option: create a java proxy and use JDBC or SQLJ to connect to the database.

Regards,

Matias.

[JohnPark · Accepted solution]

yes! right! Matias.

but recently I know critical fact that we don't use JDBC. because not configure DB2 system setting for JDBC.

and I want to try other method as like java proxy or SQLJ. how can I do?

maybe you know how to implement using over the cases? then tell me please.

thank you Matias.

Regards, John.

[Former Member · Accepted solution]

Hi John !

Take a look at this documents:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/a068cf2f-0401-0010-2aa9-f5a...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/7d4db211-0d01-0010-1e8e-9b0...

Basically, a java proxy is a EJB that you deploy on the SAP Web AS (it could be the same used by SAP XI, depending on the resources needed by the proxy) that works as a sender (java proxy client) or receiver (java proxy server) adapter. This allows you to code whatever solution do you need instead of using the common provided adapters such as File, FTP, JDBC, etc. E.g. inside a java proxy server you should implement the method that receives via function parameters the incoming message (comes from XI-Integration Engine) and does whatever is necessary to send the data to the receiver end-point. In this case you could use SQLJ to connect to your DB2 Connect server.

Regards,

Matias

ps: please award points if helpful.

[JohnPark · Accepted solution]

Thank you. I'm really thank you about your reply.

but I know what is java proxy.

And I have been use a java proxy.

but I don't know how to use SQLJ and how to apply it to Java Proxy.

last question is How to connect to DB2 Connect server by SQLJ.

I know that my question is not good. but, I had got this cast at first time.

so please tell me detail answer about this problem.

Thank you Matias.

Regards John.

[Former Member · Accepted solution]

Hi John !!

This links will provide a great source of examples and reference for developing a SQLJ program inside a java proxy

http://www.javaolympus.com/J2SE/Database/SQLJ/SQLJ.jsp

http://www.ibm.com/developerworks/db2/library/techarticle/dm-0412cline/

http://www.javaworld.com/javaworld/jw-05-1999/jw-05-sqlj.html?page=1

Regards,

Matias.

[JohnPark · Accepted solution]

Wow great!!! Thank you Matias.

I'm study hard your reply. thank you. ^^*

Could you tell me your e-mail to "submitjh@naver.com".

I want to continues communication with you.

Thank you.

ps. call me John. ^^

Regards, John.