Where would you specify the DECLARE CURSOR statement?

[Krishna]

Where would you specify the DECLARE CURSOR statement?

[jyoraj]

In working Storage section.

[dbzTHEdinosauer]

since the question is Where would
my answer would be according to site standards

had the question been Where could
my answer would have been either in Working-Storage, Linkage, or Procedure Division (physically before the OPEN and the FETCH.

[fredrick andrews]

Hi dbzTHEdinosauer,

Thanks for the answer.
Sure, we can do it .

But, is there any difference when doing these?

I mean, any performance advantage or anything at all..?

Thanks in advance.

[dbzTHEdinosauer]

Fredrick Andrews,

no difference, not performance advantage.

it is cosmetic. by that i mean, it depends on the coding standards for the site.

i have worked at sites and have seen all three methods employed.
just depends on where the coding standards stipulate the code must be layed.

remember, a declare cursor is not an invocation of SQL.
it is used by the pre-compiler to generate the code placed between the PROCEDURE DIVISION statement and the first line of user code.
The inserted code is executed once, regardless of number of times the program is CALLed,
as long as the program is not CANCELed or has the INITIAL statement in the ID Division.