Hi,
I tried to get the connection with DB2/OS390 v.7.1 by using IBM JDBC driver,aka dbjcc.jar.
I got a message that show the prerequisite stored procedures not installed on DB2/OS390 when my java application with the com.ibm.db2.jcc.DB2Driver connected with the DB2 .
The IBM article said that these stored procedures below could be found in PTFs (PTFs Number is UQ72083 )for DB2 for OS/390 and z/OS
DB2
o SQLCOLPRIVILEGES
o SQLCOLUMNS
o SQLFOREIGNKEYS
o SQLGETTYPEINFO
o SQLPRIMARYKEYS
o SQLPROCEDURECOLS
o SQLPROCEDURES
o SQLSPECIALCOLUMNS
o SQLSTATISTICS
o SQLTABLEPRIVILEGES
o SQLTABLES
o SQLUDTS
o SQLCAMESSAGE

The questions are:
1).These stored procedure can really solve the problem that the error message showed ?
2).Where to find/download the PTFs for DB2 for OS/390 , that is where to find/download these stored procedures ?

Best regards,
Kevin

Hi,

The attached file seems something wrong last post.
I post once more this time.
sorry!

Kevin

Hi Kevin,

I did a google search and came across this link.

http://www-306.ibm.com/software/data.../javaspbi.html

see if this is helpful.

Cheers

Nitin