Skip to Content
avatar image
Former Member

Query DB2 on z/OS from J2EE

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 24, 2009 at 12:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded