Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8 Answers
- 33022 Views
- CGI, Wipro, I also Faced
- E-Mail Answers
Answer Posted / budgobbel
In CICS programs, data is passed in the Communications Area (CA) via the Linkage Section.
If your cursor is predicated (WHERE clause) on a field in the CA, you could code your cursor early in the Procedure Division prior to any open cursor logic. This will avoid using additional variables, and MOVE statements.
If you keep your cursor in the Working Storage area, you cannot use fields in the Linkage section as host variables, because the DB2 pre-compiler will see the cursor first, and NOT have a resolution for the host variable (it hasn't seen the Linkage Section, yet).
It mostly is up to you, unless your shop is a stickler on variables and locations, etc.
Also, over the years I have seen shops become more code-it-and-load-it in philosophy. Very sad.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is query_cache_limit?
What is the difference between using bind () and rebind () methods of naming class?
What is sqlca?
What is the use of reorg in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the maximum size of a char data type in db2?
What is a db2 cursor?
Which component is used to execute the sql statements?
What is the difference between oracle and db2?
What is runstats utility in db2?
What do you mean by cursor?
List out the buffer pools in db2
What is runstats and reorg in db2?
What does db2 plan contain?
How to find the number of rows in a db2 table?
