Interested to Buy Any Domain ? << Click Here >> for more details...
what is Runstats? Whem will u choose to runatats?
- 1 Answers
- 13190 Views
- Danske, I also Faced
- E-Mail Answers
Answer / s
RUNSTATS is run when there is heavy insert/update activity
that changes the characteristics of the data to a great
extent. Follow REORG with RUNSTATS. Usually after REORG to
record the organized data so that optimizer chooses a
better access path.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is the use of db2?
What is the cascade rule and how does it relate to deletions made with a subselect?
how can u understand the end of the table ?
How many buffer pools are available in db2?
What is a DB2 plan?
How can record locking be achieved in those DB2 versions which do not support it?
Explain the function of data manager.
If I have a view which is a join of two or more tables, can this view be updateable?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
What is a thread?
COBOL 
