How do you leave the cursor open after issuing a COMMIT ?
Use WITH HOLD option in DECLARE CURSOR statement. But, it has not effect in psuedo-conversational CICS programs.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
When you COMMIT, is the cursor closed ? 28.07.08
Yes....What happens when you say OPEN CURSOR ? 28.07.08
If there is an ORDER BY clause, rows are fetched, sorted and made available for the FETCH statement. Other wise simply the cursor is placed on the first row....What is the difference between POST-DATABASE-COMMIT and POST-FORM-COMMIT? 20.05.08
POST-FORM-COMMIT fires once during the Post and Commit Transactions process, after the database commit occurs. The Post-Forms-Commit trigger fires after inserts...Difference between an implicit & an explicit cursor? 11.05.08
PL/SQL declares a cursor implicitly for all SQL data manipulation statements, including quries that return only one row. However,queries that return more than o...How you open and close a cursor variable.Why it is required? 11.05.08
OPEN cursor variable FOR SELECT...Statement CLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used...When is the results table for the query in a DECLARE CURSOR statement created ? 10.04.08
The results table for a query specified in a DECLARE CURSOR statement of a cursor is created during the execution of the OPEN CURSOR statement....What is the significance of the CURSOR WITH HOLD clause in a cursor declaration ? 03.04.08
The clause avoids closing the cursor and repositioning it to the last row processed when the cursor is reopened....What is cursor stability ? 07.03.08
It is cursor stability that “tells” DB2 that database values read by this application are protected only while they are being used. (Changed values are...What is get cursor field? 18.03.07
GET CURSOR statement transfers the name of the screen element on which the cursor is positioned during a user action into the variable . GET CURSOR FIELD [O...How do I change the type of cursor and hide a cursor? 12.03.06
We can change the cursor type by using function _setcursortype( ). This function can change the cursor type to solid cursor and can even hide a cursor. Followin...