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 / dalwinder singh--intense tech
db2 "select name ,tbname ,typeschema,source_tabname from
sysibm.syscolumns where name='coloumn name'"
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a cursor in programming?
What is the usage of open cursor command?
How is the value function used?
Is ibm db2 open source?
What are bind parameters in db2?
What is db2 plan table?
How to retrieve rows from a db2 table in embedded sql?
What is declare cursor?
Before you give the explain statement, what are the prerogatives?
Explain package in db2 and its advantages?
How to find the number of rows in db2 tables?
How do I delete a table in db2?
How can you classify the locks in db2?
Describe major components of db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?