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
- 6344 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 a page in db2?
What is the maximum No of rows per page?
Compare a subselect to a join?
What is the use of value function?
What is the maximum size of a char data type in db2?
Can any one tell me about Restart logic in DB2.
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
What is difference between rollback and commit?
What is package versioning? Please give an example.
What is isolation level?
COBOL 
