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
- 6243 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
What is bind in db2?
What is the information associated with sysibm.syslinks table?
How would the varchar column remarks defined?
What is dbrm?
Who uses db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Explain the contention situations caused by locks?
What is role in db2?
What is sqlca’s maximum length?
How can you classify the locks in db2?
Explain the benefits you can get from mainframe connect?
How many types of page locks can be held in db2?
What is dpf in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
