DB2: A calls B once sucessfull and second time when it
calls says curson is open why is it so?
Answer / sunil
while declearing the cursor in working-storage
section 'with hold' option is used due that's why cursor
remains open while next processing
Is This Answer Correct ? | 8 Yes | 0 No |
Explain what are the various isolation levels possible?
What is CHECK PENDING ?
When is the results table for the query in a DECLARE CURSOR statement created?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What is DCLGEN?
Update command
For Read Stability locks are not applicable for phantoms, What is Phantoms?
Plan has the optimized access path in it. But is that optimized access path is attained or known
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
How to get Top 10 Salaries from a Table
How do you stop a db2 database in linux?