What are the various locking levels available?
Answers were Sorted based on User's Feedback
Answer / ram
Cursor Stability, Read Stability, Uncommited Read and Repeatable Read
| Is This Answer Correct ? | 0 Yes | 2 No |
I use CS and update a page. Will the lock be released after I am done with that page?
List down the data types in the db2 database.
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
can we update the table by using cursors can anyone post the query?
What is QUIESCE?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
Why might full image copies be faster to implement than an incremental image copy?
How do I copy a table in db2?
is it possible to get -811 error when you use cursors. why?
Name some fields from SQLCA
Discuss about db2 bind?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.