What should be specified along with a cursor in order to
continue updating process after commit?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
How can you quickly find out the # of rows updated after an update statement?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is Call attach facility? How does it work?
Can there be more than one cursor open for any program?
What do you mean by storage group (stogroup)?
What is a db2 cursor?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What is a view? Why use it?
Can any one tell me about Restart logic in DB2.