?
Solved

JAVA & DB2 & tables with underscores

Posted on 2002-04-04
3
Medium Priority
?
254 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 200 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
Suggested Courses
Course of the Month11 days, 7 hours left to enroll

752 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