What do you do to keep the cursor from closing after a
commit?
Answer / guest
You add the keyword "WITHHOLD" to the declare statement of
the cursor
Is This Answer Correct ? | 20 Yes | 0 No |
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
What parameters are used to control the free space in DB2?
What are the advantages of using a PACKAGE?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What is package in cobol db2?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
How many buffer pools are available in db2?
What is the purpose of the QUIESE Utility?
Explain what a plan is?