Interested to Buy Any Domain ? << Click Here >> for more details...
I have some 3 particular fields ..i want to know which all
tables have those 3 fields. Is there any way to identify..
can we know by quering system tables..
- 5 Answers
- 11821 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srini
select * from sysibm.syscolumns where name = <name you 3
columns here>
The above query to metadata will show you the list of table
names where these 3 columsn present
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / dalwinder singh--intense tech
db2 "select name ,tbname ,typeschema,source_tabname from
sysibm.syscolumns where name='coloumn name'"
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rajnish kumar
SELECT R.TABSCHEMA , R.TABNAME FROM
(select TABSCHEMA,TABNAME,COLNAME from syscat.columns where
COLNAME='ROLL') R
INNER JOIN
(select TABSCHEMA,TABNAME,COLNAME from syscat.columns where
COLNAME='NAME') N
ON R.TABNAME=N.TABNAME AND R.TABSCHEMA= N.TABSCHEMA
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / apoorv sharma
Learn SQL Trace for that... Tcode is ST05.
After this u will come to know which table contain those fields
| Is This Answer Correct ? | 0 Yes | 0 No |
select name ,tbname ,typeschema,source_tabname from
sysibm.syscolumns where name='coloumn name'
This statement will work.
You can try this command also.
select tabname,colname
from syscat.columns
where COLNAME='ID'
and tabschema='MYSCHEMA'
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the use of predicate?
Can we able to find all the Table names under a Particular Plan?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
What is auditing?
What is cloudant database?
What do you mean by between and in? Is between inclusive of specified range values?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
Mention the downsides of page level lock.
What is copy pending and check pending in db2?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
What is release/acquire in bind?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
COBOL 
