By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

JDBC - getColumnName for stored procedure not returning the column name

P: n/a
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?

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a


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?

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a


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

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.