This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC 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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: getTableName(int) with DB2 is not working right