Interested to Buy Any Domain ? << Click Here >> for more details...
In cursor program perform para varying until 1 by 1
fetch para cursor------close para
in the blank what will come for confirming in the database?
- 1 Answers
- 6336 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / ekalavya
You can read the variables from SQLCA. For eg. you can
check SQLCODE.
Include SQLCA in the working storage of the progarm.
EXEC SQL
INCLUDE SQLCA
END-EXEC.
then check for the SQLCODE after your SQL query.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain the benefits you can get from mainframe connect?
What is a db2 cursor?
What is isolation level in db2?
How to execute stored procedure in db2 command editor?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is netezza database?
Explain about mirror activator disk mirroring?
What does sqlcabc has?
How do I add a column in db2?
How do I create a view in db2?
what is a corelated subquerry?
What is load utility in db2?
What is db2 command?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is ibm db2 used for?
