Interested to Buy Any Domain ? << Click Here >> for more details...
What are the various locking levels available?
- 3 Answers
- 6671 Views
- I also Faced
- E-Mail Answers
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 |
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
What is db2 bind process?
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.
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
What is a cursor in programming?
Can we update view in db2?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
wht steps we need will coding cobol and db2 pgm ?
How many Buffer pools are there in DB2 and what are they?
how can we find nth max salary from A table
What is meant by concurrency?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
COBOL 
