XI to AS/400 DB2 connectivity_doubt

[Former Member]

Hi,

has anyone connected to an AS/400 DB2 from XI's Sender JDBC Adapter? if so, can you please suggest the procedure and the <b>driver</b> that was used.

Regards,

Balaji.M

[former_member431549]

Definitely possible and Jai provided correct driver string. We even use stored procedures on as/400 for sender comm channels to use.

[Former Member]

Hi All,

Thank you for the response. i have downloaded the <b>jt400.jar</b> and installed in XI.

i am in doubt about the connection string i should be using in XI JDBC Sender Adapter.

the details i have at this point is

AS/400 server IP - available

port number - not available

LocationName - NBHAGWAT

Table Name - STGORDOPDH

can you help me with the connection string?

should it be one of the below or something else:

jdbc:as400://IP/NBHAGWAT

or

jdbc:as400://IP:446;LocationName=NBHAGWAT

or

jdbc:as400://IP:446;collectionName=NBHAGWAT

or

port number replace with 50000(instead of 446)

Thank you,

Regards,

Balaji.

[former_member431549]

We have the following parameters.

JDBC driver -

com.ibm.as400.access.AS400JDBCDriver

Connection - jdbc:as400://myas400.mycompany.com;naming=sql;errors=full;libraries=mylibrary

There are numerous options which can be added to the end of the connection string depending on your requirements. We didn't have to specify port. I think it uses the default for JDBC, which I can't recall at the moment. Table name is in your SQL SELECT or stored procedure.

[Former Member]

Balaji,

It is possible to connect XI to AS/400 database. This is the connection URL we used in sender JDBC adapter.

<b>com.ibm.as400.access.AS400JDBCDriver</b>

Just search in IBM website, you will find the reqd JDBC drivers.

Best Wishes,

Jai Shankar

[Former Member]

Hi,

See this thread.

Regards,

Sudheer.