Re: CLOSQLCSR=*ENDMOD

[Stuart Rowe <rowestu@xxxxxxxxx>]

I'd be interested as well.

I've wondered for years exactly what this does.  I always thought it was for
modules that are the main module of a program (main module exits due to
"return" but program stays loaded) -- because it certainly does nothing when
used in modules that are just bound in as extras -- at least I have noticed
no difference from *ENDACTGRP.  Maybe it is an OPM hold-over?

Stu


On Tue, Oct 25, 2011 at 14:25, Hockchai Lim
<lim.hock-chai@xxxxxxxxxxxxxxx>wrote:

> Below is from the V5R4 SQL Reference manual:
> CLOSQLCSR=*ENDMOD ==> SQL cursors are closed and SQL prepared statements
> are implicitly discarded when the module is exited. LOCK TABLE locks are
> released when the first SQL program on the call stack ends.
>
> can someone help me understand what “when the module is exited” in the
> above statement means?  As far as I know, module object is not an executable
> object.  So, I couldn’t quite understand what it mean?
>
> thanks
>
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.