Interested to Buy Any Domain ? << Click Here >> for more details...
cursor with hold explain ?
- 1 Answers
- 6353 Views
- Verizon, I also Faced
- E-Mail Answers
Answer / ratheesh nellikkal
Hi All,
Cursor is nothing but a pointer to a result set that you
get as a result of executing a query.
So if u wanna some operations using this cursor then u have
to
1. Declare a cursor
2.Open the cursot before the first access
3.Do the operations
4.Close the cursor.
But in case of a normal cursor (not declared with 'with
hold' option) in between the operations if u issued a
commit command then the cursor will be getting closed and
if u wanna access it again then u should open it again.
But incase of a 'With hold' cursor it will maintane the
states if you issed a commit also.
Means it will not get closed by applying frequent commit.
Regards,
Ratheesh Nellikkal
| Is This Answer Correct ? | 8 Yes | 0 No |
What is a buffer pool?
How many buffer pools are there in DB2?
What is the purpose of the DSNC transaction ?
What is the logical entity between plan and Package?
how can u retrieve the data from null values using applicaion program.
What are the contents of dclgen?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
What is collection in db2 bind?
What is a base table?
What is db2 stogroup?
What is an instance in db2?
What is index in db2?
COBOL 
