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
- 5376 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 |
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What does a deadlock mean in DB2?
How many clustering indexes can be defined for a table?
Is schema the same as database?
How many Buffer pools are there in DB2 and what are they?
What if we fail to give values in columns declared as NOT NULL ?
How do you stop a db2 database in linux?
What is a NULL value? What are the pros and cons of using NULLS?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
List out the buffer pools in db2
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
COBOL 
