what is the difference between declaring the cursor in WS
section and Procedure division?
Answer / madhavi chava
As definition of cursor is non executable statement, it is
advisable not to define in procedure division as it may
misunderstood others.
we can define it any where only thing you have to take care
is definition of cursor should be prior to the OPEN
statement of the same cursor.
Is This Answer Correct ? | 18 Yes | 1 No |
What is the specific need of Plan and..where are the tables in DB2 are physically saved
pls explain the precompilation process of cobol-db2 pgm
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is a synonym ?
what are the SQL codes u freequently got?
How many buffer pools are available in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is reorg and runstats in db2?
What is correlation names?
What is DYNSLT keyword? How do you perform selection using DYNSLT
Normalization in DB2 – first normal form, second normal form