Cursors can be declared in both working-storage & procedure
division, Agreed.
But is there any difference? If could you please suggest
what is the difference.
TIA
Answer Posted / sathish
This can be declared in both the sections. But not sure
what is the diff.
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
What are the two types of logging in the db2 database? Explain them.
Where do you specify them?
Define check constraint.
What is the syntax for seeing the columns and data types of a table in the db2 database?
How to execute stored procedures?
Are view updateable?
What are foreign keys in db2?
What is explain plan in db2?
Define sqlca.
On which levels locks can be applied?
What is access path in db2?
What is the difference between using bind () and rebind () methods of naming class?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the difference between dbm cfg and db cfg file in db2 ?
What is temporal table in db2?