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 / 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 |
How do you run JCL in cobol program
what is a plan and how do you refer the plan in the program?
I use CS and update a page. Will the lock be released after I am done with that page?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
can i code union in cobol-db2 pgm ?
What is the information associated with sysibm.syslinks table?
How do I copy a table in db2?
What is the purpose of using commit?
What are the disadvantages of using VARCHAR?
What is blu acceleration in db2?
Define sqlca.
How to connect to db2 database from windows command line?