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 can we read records for specific member in CL? AND rpg?
Explain in detail about buffer manager and its functionalities?
Explain about rct.
Why cursor is used in db2?
What is db2 catalog database?
What is rct?
How to find the number of rows in db2 tables?
Is db2 a database?
What is cursor stability in db2?
How do I change the column size in db2?
What is a db2 schema?
Define check constraint.
How do I copy a table in db2?
List down the data types in the db2 database.
What is sqlca’s maximum length?