How to fetch the uncommited data from table ?
Answer / sudhir kumar
With the help of restart checkpoint logic.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a subselect? Is it different from a nested select?
what is static sql? what is dynamic sql? Give me details
What should be specified along with a cursor in order to continue updating process after commit?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
When is the skeleton cursor table created?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is a result table?
what is SPUFI ?
Define db2 and its databases?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
db2 restart logic ?
how can u nderstand the sql stmts executed successfully or not ?