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
- 6247 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's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
On which levels locks can be applied?
How does db2 sample database connect?
Which transaction use a command thread ?
What are the various locks available?
Explain in brief how does db2 determine what lock-size to use?
What is ibm db2 client?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
Give a brief description of db2 isolation levels?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
What is a NULL value? What are the pros and cons of using NULLS?
COBOL 
