What do you do to keep the cursor from closing after a
commit?
- 1 Answers
- 6489 Views
- I also Faced
- E-Mail Answers
Answer / guest
You add the keyword "WITHHOLD" to the declare statement of
the cursor
| Is This Answer Correct ? | 20 Yes | 0 No |
How do you check for a null value in a db2 column?
Suppose if I need to update a column, how you do that using cursor?
What is a base table?
What is view db2?
what is copy pending and check pending ?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
What is a DB2 catalog?
Can we insert update delete in view?
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,
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
When do you specify the isolation level?
COBOL 
