JDBC - getColumnName for stored procedure not returning the column name

[fsa3]

Hi,

I have some JDBC calling a DB2 mainframe (os/390) when I get the result
set back from a stored procedure call and get the ResultSetMetaData and
try to execute rsmd.getColumnName(1) all I get back is the String "1"
not the column name.

Has anyone seen this issue?

[Joe Weinstein]

fs**@optonline.net wrote:

Hi,

I have some JDBC calling a DB2 mainframe (os/390) when I get the result
set back from a stored procedure call and get the ResultSetMetaData and
try to execute rsmd.getColumnName(1) all I get back is the String "1"
not the column name.

Has anyone seen this issue?

What is the query the procedure is doing? Is that column directly from a
table, or is it a computed column etc?

[fsa3]

It's basically doing a select colName as MyColName from tableX;

Very simple and straight forward. Some google'ing has found that this
is a known issue with some versions of db2. The fix seemed to be to
use a ZPARM called DESCSTAT. However at this time I don't have access
to change that.

Any other thoughts are appreciated.

Frank

[Joe Weinstein]

fs**@optonline.net wrote:

It's basically doing a select colName as MyColName from tableX;

Very simple and straight forward. Some google'ing has found that this
is a known issue with some versions of db2. The fix seemed to be to
use a ZPARM called DESCSTAT. However at this time I don't have access
to change that.

Any other thoughts are appreciated.

Frank

Ok, then it seems that you're hosed. If the DBMS isn't
sending the metadata along with the data, there's nothing
you or the driver can do about it.
Wish I could help,
Joe Weinstein at BEA Systems