Solved

JAVA & DB2 & tables with underscores

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Eclipse Neon and jdk 1.8.0 11 138
eclipse java  build path 6 44
maven project error 5 48
Java JRE greater than 1.6 5 50
This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
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 step-by-step guide to install VisualVM launcher in eclipse.

920 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

17 Experts available now in Live!

Get 1:1 Help Now