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
- 9752 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the various isolation levels possible?
How do I copy a table in db2?
How to restart a DB2 program?
What are bind parameters in db2?
What action db2 takes when a program aborts in the middle of a transaction?
define clustering index.
Define check constraint.
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What db2 400?
What is a db2 package?
Explain about rct in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
List out the three types of page locks that can be held.
My sql statement select avg(salary) from emp yields inaccurate results. Why?
