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
What is dbrm? When it will be created?
How to compare data between two tables in db2?
Mention the different locking levels that are available in db2.
How many types of page locks can be held in db2?
How to retrieve rows from a db2 table in embedded sql?
Mention the definition of cobol in varchar field.
Explain about mirror activator disk mirroring?
Which isolation level provides highest data integrity?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
what are bind concepts in db2 cobol?
What is dclgen in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is load utility in db2?
How to find primary key of a table in db2?
How can you count the number of rows from a table tab?