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

Answer / dalwinder singh--intense tech

db2 "select name ,tbname ,typeschema,source_tabname from
sysibm.syscolumns where name='coloumn name'"

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

Answer / apoorv sharma

Learn SQL Trace for that... Tcode is ST05.

After this u will come to know which table contain those fields

Answer / ratheesh nellikkal

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'

Give a brief description of db2 isolation levels?

0 Answers  

Which is faster delete or truncate?

0 Answers  

What is dpf in db2?

0 Answers  

What is sqlcode -922 ?

2 Answers  

What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,

What is PRIME TABLE and what are the uses of it

1 Answers  

What are types of indexes?

0 Answers  

what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,

how to resolve -811

2 Answers   IBM,

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

What is the function of logging in the db2 database?

0 Answers  

What does the sqlcode of -818 pertain to?

3 Answers