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 / apoorv sharma
Learn SQL Trace for that... Tcode is ST05.
After this u will come to know which table contain those fields
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why select is not preferred in embedded sql programs?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is multi row fetch in db2?
What is buffer pool?
What is host variable?
What does reorg do in db2?
How many types of page locks can be held in db2?
What is ibm db2 connect?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is a collection in db2?
How to find primary key of a table in db2?
What are the rules for db2 programming?
What is check constraint in db2?
Which isolation level provides maximum concurrency?
What does db2 blu stand for?