Solved

JAVA & DB2 & tables with underscores

Posted on 2002-04-04
3
248 Views
Last Modified: 2010-03-31
I have a db2 database running on linux and a java program that uses this database everything works fine till I try to query a table with more than one underscore (ex: partner_type_w) for any of these tables db2 says the table does not exist.  why?
0
Comment
Question by:calvinrsmith
3 Comments
 
LVL 9

Expert Comment

by:yongsing
Comment Utility
Are you sure you didn't get the table name wrong? Open the command window on the client, connect to the database, and do a "db2 list tables for user" to check.
0
 
LVL 3

Accepted Solution

by:
jerelw earned 50 total points
Comment Utility
try logging into db2 and entering list tables for schema [instance] to see if your table does indeed exist.
0
 
LVL 1

Author Comment

by:calvinrsmith
Comment Utility
thanks for that idea it works now turns out the table was not
partner_master_w
but was instead
partner_master_vv
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

For customizing the look of your lightweight component and making it look lucid like it was made of glass. Or: how to make your component more Apple-ish ;) This tip assumes your component to be of rectangular shape and completely opaque. (COD…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now