Interested to Buy Any Domain ? << Click Here >> for more details...
Can we able to find all the Table names under a Particular
Plan?
- 1 Answers
- 6765 Views
- CTS, I also Faced
- E-Mail Answers
Answer / vat
Absolutely! Just look at the catalog table SYSIBM.SYSPLANDEP
It's pretty straight forward! It recrods the dependencies
of plans on tables, views, synonyms, table spaces, indexes,
aliases, functions and stored procedures.
| Is This Answer Correct ? | 12 Yes | 0 No |
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
Give the COBOL definition of a VARCHAR field.
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
What is the difference between Where and Having Clause
What is the physical storage length of the data types date, time, and timestamp?
How to compare data between two tables in db2?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
Are views updatable ?
What is the cascade rule and how does it relate to deletions made with a subselect?
What are delete-connected tables?
What is a Resource Control Table(RCT)? Describe its characteristics.
What is image copy in db2?
COBOL 
