cancel
Showing results for 
Search instead for 
Did you mean: 

Query DB2 on z/OS from J2EE

Former Member
0 Kudos

We are running NW 7.0 SP14 on AIX / Oracle.

We have a need to query a DB2 table that is running in our mainframe environment (z/OS).

Do we need to use DB2Connect for this or can I use a standard JDBC?

Or is it more complicated than it appears?

Anyone done anything like this?

Got any how to documentation?

Thanks,

JB

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Joe,

all you have to do is the following:

via J2EE Administrator tool, JDBC Connector Service create new driver, building upon two files: first - jdbc db2 driver, and the former - file license (something like cruiz), both of them are taken from your DB2 team (or you can get temporarily license from the Marketplace).

Then you have to create the JDBC connection itself (It's called DataSource) build on the driver you've defined on the previous step, with the DB name, user, password and etc...

While executing queries, please, do not forget to choose "Vendor SQL" type of SQL.

Here It Is path to the subject from help.sap.com:

http://help.sap.com/erp2005_ehp_04/helpdata/DE/c7/641f44be9f1e4ebbe807cfbad61d44/frameset.htm

With best regards,

Vladimir

Edited by: Vladimir Pavlovsky on Jan 24, 2009 7:17 PM

Answers (0)