cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC driver to AS400

Former Member
0 Kudos

Hi,

I want to call a DB on AS 400 OS.

do i need to deply the JDBC to the XI first?

does anyone know which driver i should use?

thanks

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

HI Udi,

pls take a look at http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzahh/javadoc/JDBCProperties.html

First you have to deploy with SDM the corresponding Drivers.

In my case the driver is:

com.ibm.as400.access.AS400JDBCDriver

Then in your configuration Channel you have to use this string:

jdbc:as400://"Your IP":446/"Your Schema";date format=iso;date separator=-

Good luck.

JJ

Former Member
0 Kudos

Refer to the documentation on the URL

http://as400bks.rochester.ibm.com/html/as400/v4r5/ic2924/index.htm?info/java/rzaha/jdbc.htm

It is the driver for DB2.

If your XI server does not have the DB2 drivers already installed, you will have to install the same.

There is a new tool available at Service Marketplace which makes it easy to deploy JDBC / JMS driver.

the URL is

https://websmp105.sap-ag.de/~sapdownload/011000358700007048402005E/HowInstallExternalDriver.zip

Check out the drivertool utility in this zip.

Regards,

Amol

PS : Please reward points for useful posts.

Message was edited by: Amol Joshi

former_member184154
Active Contributor
0 Kudos

I am using the AS/400 Toolbox for java, instead of AS/400 DevKit4Java, and I found this other IBM page very useful.

http://as400bks.rochester.ibm.com/html/as400/v4r5/ic2924/info/java/rzahh/jdbc.htm

Regards,

Alex

bhavesh_kantilal
Active Contributor
0 Kudos

Hi Udi,

//do i need to deply the JDBC to the XI first?

Yes. To access any Database from XI, the corresponding driver has to be deployed on your XI server.

For info on how the drivers have to be installed, check these links,

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

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5d...

Regards,

Bhavesh

Message was edited by: Bhavesh Kantilal