Answer Posted / krishnan
CS-cursor stability
RR-repeatable read
UR-uncommited read
CR-Cursor Readabiliy
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Which is faster delete or truncate?
Give the name of some fields form sqlca.
Why cursor is used in db2?
Explain what are the various isolation levels possible?
Define buffer pool.
What are union and union all?
What is role in db2?
What is sqlca’s maximum length?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Who uses db2?
What is an instance database?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is view db2?
What does runstats do in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?