Here is a simple DB2 - SQL  command to find a particular table name exists in given database name. 
Example :
Database name : FRSDB
Table Name : DB_VERSION
C:\Users\ADMIN>db2 connect to frsdb
Database Connection Information
Database server = DB2/NT64 10.1.0
SQL authorization ID = KRISHNA
Local database alias = FRSDB
C:\Users\ADMIN>db2 SELECT TABNAME FROM SYSCAT.TABLES WHERE TABNAME ='DB_VERSION'
TABNAME
--------------------------------------------------------------------------------------------------------------------------------
DB_VERSION
1 record(s) selected.
C:\Users\ADMIN>
SELECT TABNAME FROM SYSCAT.TABLES WHERE TABNAME ='' 
Example :
Database name : FRSDB
Table Name : DB_VERSION
C:\Users\ADMIN>db2 connect to frsdb
Database Connection Information
Database server = DB2/NT64 10.1.0
SQL authorization ID = KRISHNA
Local database alias = FRSDB
C:\Users\ADMIN>db2 SELECT TABNAME FROM SYSCAT.TABLES WHERE TABNAME ='DB_VERSION'
TABNAME
--------------------------------------------------------------------------------------------------------------------------------
DB_VERSION
1 record(s) selected.
C:\Users\ADMIN>
Thursday, January 03, 2013
 // 
Labels:
DB2
 // 
0
comments
 // 
0 comments to "Select particular table name from given database in db2"
Popular Posts
- 
The best solution to know about these init levels is to understand the " man init " command output on Unix. There are basically 8...
 - 
How to Unlock BSNL 3G data card to use it with Airtel and Vodafone Model no : LW272 ? How to unlock BSNL 3G data card( Model no : LW272 )us...
 - 
How to transfer bike registration from one State to other (Karnataka to Andhra)?? Most of us having two wheelers purchased and registered in...
 - 
ఓం శ్రీ స్వామియే శరణం ఆయ్యప్ప!! Related posts : Trip to Sabarimala - Part 1 Trip to Sabarimala - Part 2 Ayappa Deeksha required things...
 - 
Following are some of interesting blogs I found till now ...please comment to add your blog here. Blogs in English : http://nitawriter.word...
 
Popular posts
- Airtel and vodafone GPRS settings for pocket PC phones
 - Andhra 2 America
 - Ayyappa Deeksha required things
 - Blogs I watch !
 - Captions for your bike
 - DB2 FAQs
 - Deepavali Vs The Goddes of sleep
 - ETV - Dhee D2 D3
 - Evolution of smoking in India Women
 - How to make credit card payments?
 - init 0, init 1, init 2 ..
 - Java-J2EE interview preparation
 - mCheck Application jar or jad download
 - My SQL FAQs
 - My Travelogues
 - Old is blod - New is italic
 - Online pay methids for credit cards
 - Oracle FAQs
 - Pilgrimages
 - Smoking in Indian Women
 - Technology Vs Humans
 - Twitter feeds for all Telugu stars on single page.
 - Unix best practices
 - Unix FAQs
 



Post a Comment
Whoever writes Inappropriate/Vulgar comments to context, generally want to be anonymous …So I hope U r not the one like that?
For lazy logs, u can at least use Name/URL option which doesn’t even require any sign-in, The good thing is that it can accept your lovely nick name also and the URL is not mandatory too.
Thanks for your patience
~Krishna(I love "Transparency")