select name ,tbname ,typeschema,source_tabname from sysibm.syscolumns whe

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..

Question Posted / ratheesh nellikkal

5 Answers
11871 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / 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'

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is reorg?

1164

Explain about cursor stability?

1055

What are the prerogatives?

1083

How can you do the explain of a dynamic sql statement?

1069

What is db2 bind?

1088

Where do you specify them?

1289

Why do we use cursor?

1106

What are the benefits of using the db2 database?

1234

What is the cobol picture clause of the db2 data types date, time, timestamp?

1068

Is ibm db2 free?

1015

What is precompiler in db2?

1024

can all users have the privilage to use the sql statement select * (dml)?

1175

What is bind plan?

1053

How can we read records for specific member in CL? AND rpg?

706

What is catalog database in db2?

1172