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..
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 full forms of spufi and dclgen and why are they used?
What is clone table?
What is the difference between db2 and oracle?
What is collection in db2 bind?
What is database reorganization?
What is drop table?
What is db2 connect?
Define db2.
What is runstats utility in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What types of tables are there in the db2 database?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What are the various isolation levels possible?
What's The Percentage Free Space ?
What is a db2 cursor?