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
Can we update view in db2?
How to restart a DB2 program?
List out the data types available.
What is dbrm?
What is explain in db2?
What are catalog tables in db2?
What is an instance database?
Why do we bind in db2?
Discuss about db2 bind?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Name the lockable units in DB2?
What is the use of runstats in db2?
Which component is used to execute the sql statements?
What is check constraint in db2?
How do I add a column in db2?