This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Customer Requirements for Developers and have Marcho Behler on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes getTableName(int) with DB2 is not working right Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "getTableName(int) with DB2 is not working right" Watch "getTableName(int) with DB2 is not working right" New topic
Author

getTableName(int) with DB2 is not working right

pellmika
Greenhorn

Joined: Jul 16, 2001
Posts: 2
Hi, I just want to retrieve the table name associated to a column ( for sql orders with multiple tables ) with DB2. However, it always returns "". However, the values and column names are retrieved correctly. I tried to prefix everything in my sql orders :
( select table_name.field_name from schema.table_name ).
It always returns ""!
Is there a problem with the DB2Driver?
Frank Carver
Sheriff

Joined: Jan 07, 1999
Posts: 6920
"pellmika",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in with a new name which meets the requirements.
Thanks.


Read about me at frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: getTableName(int) with DB2 is not working right
 
It's not a secret anymore!