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?
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
How to access db2 tables in mainframe?
Mention data types used in db2 ?
What do you mean by cursor?
What is performance tuning db2?
What is the physical storage length of time data type?
What is database manager in db2?
i want to maintain uniqueness on pdf without make lf??????????
Define sqlca.
Is ibm db2 free?
What is a buffer in memory?
What kind of database is db2?
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 ?
What do you mean by storage group (stogroup)?
What is dbrm?
What is the difference between oracle and db2?