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
- 6763 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 |
How do you retrieve the data from a nullable column?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
Define check constraint.
What is sqlca?
What is the use of runstats in db2?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What are the various isolation levels possible?
how to resolve -818 error. how to see timestamp token in load module and plan
What is the SQL query to select, delete and get count of duplicate rows in DB2?
How do you do the EXPLAIN of a dynamic SQL statement?
How do I import data from excel to db2?
what's the error code for Unique Index Violation?
COBOL 
