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'

i want to delete 20th million record how ?

4 Answers   IBM,

---

What is a predicate?

1 Answers  

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

How to compare data between two tables in db2?

0 Answers  

---

---

Explain the function of data manager.

0 Answers  

---

What is the use of db2?

0 Answers  

---

Can you use max on a char column?

0 Answers  

---

What is the difference between base table and view?

7 Answers  

---

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

---

How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

What is the default page size of buffer pools?

0 Answers  

---