IBM DB2 Question: Download IBM DB2 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.
Tweet Share WhatsApp

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 PDF Read All 32 IBM DB2 Questions
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?

Keep in touch with us

Copyright © 2005 -  2024
www.globalguideline.com All rights reserved.