Professional Web Applications Themes

getColumnName() with DB2 v7 on z/OS - IBM DB2

Hello, I have stored procedure that executes on DB2 version on z/OS. I'm calling it in a servlet. It works, but I would like to get the column name. Instead, the ResultSetMetaData getColumnName() just returns the column number. getColumnLabel() does the same. I can run it in Stored Procedure Builder, and I get the same thing... so it's not a Java issue. Is there some magic parameter to set in DB2 on z/OS that makes it return the column info? thanks, Greg Groves Florida Hospital...

  1. #1

    Default getColumnName() with DB2 v7 on z/OS

    Hello,

    I have stored procedure that executes on DB2 version on z/OS. I'm
    calling it in a servlet. It works, but I would like to get the column
    name. Instead, the ResultSetMetaData getColumnName() just returns the
    column number. getColumnLabel() does the same.

    I can run it in Stored Procedure Builder, and I get the same thing...
    so it's not a Java issue.

    Is there some magic parameter to set in DB2 on z/OS that makes it
    return the column info?

    thanks,

    Greg Groves
    Florida Hospital
    Greg Groves Guest

  2. #2

    Default Re: getColumnName() with DB2 v7 on z/OS

    Can't find back my source but i think the solution was either
    a ptf on the mainframe and/or a patch1/patch2 setting in the db2cli.ini
    file.

    Not sure, maybe it relates to this one ( APAR IY30655)
    [url]http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infoce[/url]
    nter.d2w/report?target=mainFrame&fn=r0008109.htm

    You can review previous posts containing getColumnName getColumnLabel here
    [url]http://groups.google.ca/groups?num=100&hl=en&lr=&ie=ISO-8859-1&scoring=d&q=g[/url]
    etColumnName+OR+getColumnLabel++group%3Acomp.datab ases.ibm-db2

    PM


    "Greg Groves" <greg.grovesflhosp.org> a écrit dans le message de news:
    [email]c1cda17f.0306260657.5eeb3309posting.google.com[/email]...
    > Hello,
    >
    > I have stored procedure that executes on DB2 version on z/OS. I'm
    > calling it in a servlet. It works, but I would like to get the column
    > name. Instead, the ResultSetMetaData getColumnName() just returns the
    > column number. getColumnLabel() does the same.
    >
    > I can run it in Stored Procedure Builder, and I get the same thing...
    > so it's not a Java issue.
    >
    > Is there some magic parameter to set in DB2 on z/OS that makes it
    > return the column info?
    >
    > thanks,
    >
    > Greg Groves
    > Florida Hospital

    PM \(pm3iinc-nospam\) Guest

  3. #3

    Default Re: getColumnName() with DB2 v7 on z/OS

    Maybe...
    look for zparm on the page.

    [url]http://www-3.ibm.com/software/data/pubs/papers/sqlj/[/url]

    PM

    "Greg Groves" <greg.grovesflhosp.org> a écrit dans le message de news:
    [email]c1cda17f.0306260657.5eeb3309posting.google.com[/email]...
    > Hello,
    >
    > I have stored procedure that executes on DB2 version on z/OS. I'm
    > calling it in a servlet. It works, but I would like to get the column
    > name. Instead, the ResultSetMetaData getColumnName() just returns the
    > column number. getColumnLabel() does the same.
    >
    > I can run it in Stored Procedure Builder, and I get the same thing...
    > so it's not a Java issue.
    >
    > Is there some magic parameter to set in DB2 on z/OS that makes it
    > return the column info?
    >
    > thanks,
    >
    > Greg Groves
    > Florida Hospital

    PM \(pm3iinc-nospam\) Guest

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