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


Please Help Members By Posting Answers For Below Questions

How can we read records for specific member in CL? AND rpg?

419


Explain in detail about buffer manager and its functionalities?

756


Explain about rct.

844


Why cursor is used in db2?

751


What is db2 catalog database?

771






What is rct?

949


How to find the number of rows in db2 tables?

779


Is db2 a database?

721


What is cursor stability in db2?

1025


How do I change the column size in db2?

802


What is a db2 schema?

958


Define check constraint.

822


How do I copy a table in db2?

740


List down the data types in the db2 database.

793


What is sqlca’s maximum length?

870