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
- 6350 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 various types of locks in db2?
What is the use of value function?
Are view updateable?
What is the difference between plan and package in db2?
What is db2 catalog database?
How connect db2 database to datastage?
How to find the number of rows in a db2 table?
How do I add a column to a table in db2?
Explain how can you do the explain of a dynamic sql statement?
What are the benefits of using the db2 database?
How can you quickly find out the # of rows updated after an update statement?
What is a trigger in the db2 database?
How would the varchar column remarks defined?
Is db2 relational database?
What is blu acceleration in db2?
