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
- 12058 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / srini
select * from sysibm.syscolumns where name = <name you 3
columns here>
The above query to metadata will show you the list of table
names where these 3 columsn present
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to create db2 table in mainframe?
What is the maximum size of varchar data type in db2?
What is explain plan in db2?
List some fields from sqlca?
What are the rules for db2 programming?
B37 abend during spufi?
What are the contents of a dclmgen?
What is deadlock in db2?
What is innodb buffer pool?
What is the picture clause of null indicator variable?
List out the data types available.
What is a plan and package in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How to access db2 tables in mainframe?
What is runstats utility in db2?
