IBM DB2 Question:
Download Questions PDF

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:

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

Download IBM DB2 Interview Questions And Answers PDF

Previous QuestionNext Question
Can i insert bulk records into a db2 table using qmf of
spufi only.
when we are tying to update a table having 100 rows. if the
program abends when updating 51 row . how to start updating
again from the 51 row . What was the logic?