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?
- 1 Answers
- 5166 Views
- HCL, I also Faced
- E-Mail Answers
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 |
What is the purpose of using commit?
What does a deadlock mean in DB2?
What is an alias and how does it differ from a synonym?
Where would you find information about the type of database authority held by the user?
What is ibm db2 client?
how to resolve -811 error. give clear explination
what is the process of precompiler?
What are db2 tables?
When would you prefer to use VARCHAR?
I use CS and update a page. Will the lock be released after I am done with that page?
what is differnece between DROP TABLE & DELETE TABLE .
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
COBOL 
