Solved

JAVA & DB2 & tables with underscores

Posted on 2002-04-04
3
250 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Java contains several comparison operators (e.g., <, <=, >, >=, ==, !=) that allow you to compare primitive values. However, these operators cannot be used to compare the contents of objects. Interface Comparable is used to allow objects of a cl…
Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

776 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