MVSFORUMS.com

[mf_user]

Hi,

During a discussion, somebody raised a doubt:

Is it advisable to have Declare, Open, Fetch of Curor only? They say it is not necessary to have Close cursor statement because the DB2 takes care of it internally whether it's a rollback or commit.

They justify that having CLOSE CURSOR is necessary only if you are acting multiple times on same cursor because it requires open and close of the same cursor again and again.

Can somebody explain the technical fators please?

Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==

[CZerfas]

Hello MF,

yes, the described mechanism is correct, you don't need a CLOSE CURSOR.

Nevertheless it is good programming practice to have a CLOSE in your code. It eases maintenance, if the same cursor has to be opened with different parameters again, for instance.

It is advisable, as well, to code the "unnecessary" COMMIT into your programm, so that your coding is complete and nothing is done "automatically" by the system. Those things could change over time.

just my two cents
Christian

[mf_user]

CZerfas, Thank you.

I wrote a small DB2-COBOL program without CLOSE CURSOR and it was closed automatically.

Actually, I have never seen an explicit COMMIT in any of our programs.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==

[videlord]

most of time it's ok, even you allocate some memory without freeing in your code, system can handle it.

But i will say it's not a good code. It may depend on the compiler, the operation system. Some time it may cause problem.

Keep a good habit, make your code clear, clean.

[mf_user]

Ok. Thank you videlord.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==

[dr_te_z]