Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: where to find the prerequisite stored procedures for db2

    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
    Attached Thumbnails Attached Thumbnails error_pic.bmp  

  2. #2
    Join Date
    Feb 2004
    Posts
    2
    Hi,

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

    Kevin
    Attached Files Attached Files

  3. #3
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Does this help?

    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
    HTH

    Nitin

    Ask the experienced rather than the learned

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •