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
- 5170 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 |
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
What is the command used by TSO users to invoke DB2?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
how to take the back up of the DB2 table.
What is an access path?
What is cascading rollback?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
What does a deadlock mean in DB2?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
How do I create a view in db2?
Explain various types of locks in db2?
COBOL 
