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
- 6542 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 |
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What is bind package and plan in db2?
What is buffrpool? Where we use it ?
How can you get the number of rows impacted by the last executed query?
How do I create a view in db2?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
Give some example of statistics collected during RUNSTATS?
What parameters are used to control the free space in DB2?
what are the max. & min. no. of partitions allowed in a partition tablespace?
What is dbrm in db2 database?
What are the various isolation levels possible?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
COBOL 
