Interested to Buy Any Domain ? << Click Here >> for more details...
cursor with hold explain ?
- 1 Answers
- 6374 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 |
when does the SQL statement gets executed when you use cursor in the application programming ?
What is temporal table in db2?
how to take the back up of the DB2 table.
Mention the definition of cobol in varchar field.
What is the advantage in De-normalizing tables in DB2?
Could anyone clearly explain the diference between sub query and correlated sub query?
Why select is not preferred in embedded sql programs?
What can the Locate option of the Repair Utility accomplish?
What can the SET option of the Repair Utility accomplish?
Which component is responsible for processing sql statements and selecting access paths?
what is cursor stability?
What information can you find in SYSIBM.SYSLINKS table?
COBOL 
