Professional Web Applications Themes

DB2 RuntimeClient V8 and DB2 z/OS V7 ODBC question SQL0440N - IBM DB2

Anyone who can help. I've changed my DB2 Runtime Client and DB2 Connect EE from V7 to V8. But after the changing I have some problem when trying to use ODBC against DB2 z/OS V7 : "SQL0440N : NO PROCEDURE BY THE NAME SQLTABLES HAVING COMPATIBLE ARGUMENTS WAS FOUND IN THE CURRENT PATH" / "DSNT408I SQLCODE = -440, ERROR: NO PROCEDURE BY THE NAME SQLTABLES HAVING COMPATIBLE ARGUMENTS WAS FOUND IN THE CURRENT PATH" Do I have to create some new stored procedures (SQLTABLES) in the DB2 z/OS V7 environment ? If yes - please tell me where to find ...

  1. #1

    Default DB2 RuntimeClient V8 and DB2 z/OS V7 ODBC question SQL0440N

    Anyone who can help.

    I've changed my DB2 Runtime Client and DB2 Connect EE from V7 to V8.

    But after the changing I have some problem when trying to use ODBC against
    DB2 z/OS V7 :
    "SQL0440N : NO PROCEDURE BY THE NAME SQLTABLES HAVING COMPATIBLE ARGUMENTS
    WAS FOUND IN THE CURRENT PATH" / "DSNT408I SQLCODE = -440, ERROR: NO
    PROCEDURE BY THE NAME SQLTABLES HAVING COMPATIBLE ARGUMENTS WAS FOUND IN
    THE CURRENT PATH"

    Do I have to create some new stored procedures (SQLTABLES) in the DB2 z/OS
    V7 environment ?

    If yes - please tell me where to find the source for this procedures.

    Regards
    Kim Bundgaard


    Kim Bundgaard Guest

  2. #2

    Default Re: DB2 RuntimeClient V8 and DB2 z/OS V7 ODBC question SQL0440N

    My DB2 z/OS personal found the solution :

    Apply PTF UQ72083 at the z/OS DB2 UDB V7 system, and you get a hole series
    of stored procedures .

    /Kim

    "Kim Bundgaard" <kib at kmd.dk> wrote in message
    news:3f154807$0$13272$edfadb0fdread15.news.tele.d k...
    > Anyone who can help.
    >
    > I've changed my DB2 Runtime Client and DB2 Connect EE from V7 to V8.
    >
    > But after the changing I have some problem when trying to use ODBC against
    > DB2 z/OS V7 :
    > "SQL0440N : NO PROCEDURE BY THE NAME SQLTABLES HAVING COMPATIBLE
    ARGUMENTS
    > WAS FOUND IN THE CURRENT PATH" / "DSNT408I SQLCODE = -440, ERROR: NO
    > PROCEDURE BY THE NAME SQLTABLES HAVING COMPATIBLE ARGUMENTS WAS FOUND IN
    > THE CURRENT PATH"
    >
    > Do I have to create some new stored procedures (SQLTABLES) in the DB2 z/OS
    > V7 environment ?
    >
    > If yes - please tell me where to find the source for this procedures.
    >
    > Regards
    > Kim Bundgaard
    >
    >

    Kim Bundgaard Guest

Similar Threads

  1. odbc general question
    By Amaniweb in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: February 17th, 10:49 PM
  2. ODBC Database on IIS question. Where do I start?
    By Charles C. in forum ASP Components
    Replies: 3
    Last Post: June 8th, 07:46 PM
  3. DBI:ODBC-Question
    By Oliver Osterholz in forum Ruby
    Replies: 2
    Last Post: November 20th, 11:07 AM
  4. Replies: 3
    Last Post: September 12th, 04:22 AM
  5. ODBC Question
    By Manas Dadarkar in forum Informix
    Replies: 4
    Last Post: September 2nd, 01:40 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139