Solved

JAVA & DB2 & tables with underscores

Posted on 2002-04-04
3
251 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
ID: 6919819
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
ID: 6921563
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
ID: 6921636
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 Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
servlet example issue 6 46
What's wrong with this code? 4 26
SequenceInputStream example 3 19
Java syntax, or is it Selenium 6 30
For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
Viewers learn about the “while” loop and how to utilize it correctly in Java. Additionally, viewers begin exploring how to include conditional statements within a while loop and avoid an endless loop. Define While Loop: Basic Example: Explanatio…
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…

809 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