Answer / ratheesh nellikkal
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
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.
|Is This Answer Correct ?||8 Yes||0 No|
How many types of page locks can be held in db2?
why we create view.
How do I create a view in db2?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
how to execute qcmdexc in rpgle?plz write code also?
How can you split a table in to exactly half?
How do I delete a table in database?
What is the difference between IN subselects and EXISTS subselect?
What is the difference between nvl and coalesce?
What is pagespace?
What are host variables in db2?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?