on 01-23-2009 4:28 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.