Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12044 Views
- CTS, I also Faced
- E-Mail Answers
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 bind in db2?
What does db2 mean?
What is the use of predicate?
What does reorg do in db2?
What is the maximum No of rows per page?
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?
What is meant by explain?
Which command is used to remove all rows from a table?
Is ibm db2 open source?
On which levels locks can be applied?
What is cursor with hold option in db2?
Can we update view in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is database alias db2?
What are the two types of logging in the db2 database? Explain them.
