Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6242 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 happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
what is the difference between where clause and having clause
What is a db2 tablespace?
How can you quickly find out the number of rows updated after an update statement?
what is plan? is plan executable or package?
What is ALTER ?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What is meant by isolation level?
What is image copy?
What is a data page?
What is the default page size of buffer pools?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
COBOL 
