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
How many types of page locks can be held in db2?
What is ibm db2 database?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What happens in bind step in a db2 program?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is drop table?
What is db2 look?
Can you tell me how can you find out the # of rows updated after an update statement?
Explain the benefits you can get from mainframe connect?
How to view db2 table structure?
What does db2 stand for?
How does a cursor work?