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 / krishna
Since declare cursor is not a executable statement hence it
might be declared in WSS.I am not sure...
Is This Answer Correct ? | 11 Yes | 7 No |
Post New Answer View All Answers
What is the role of data manager in the db2 database?
What is scrollable cursor in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What do you mean by cursor?
What do you mean by rollback?
Define declaration generator (dclgen).
What are the various isolation levels possible?
What is copy pending and check pending in db2?
What is null in db2?
What is schema in db2?
What are the two types of logging in the db2 database? Explain them.
Why select is not preferred in embedded sql programs?
How does a cursor work?
What is query_cache_limit?
Before you give the explain statement, what are the prerogatives?