Re: SQL Close Cursor Action

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

How about putting it in a named activation group, and ending the 
activation group when the *PGM ends?

---
Scott Klement  http://www.scottklement.com

On Mon, 22 May 2006, Jeff Young wrote:

> When creating an SQLRPGLE module, the only actions I can specify for closing a 
> cursor are *ENDMOD or *ENDACTGRP.
>  What I would like to do is have all cursors closed when the program that the 
> module is a member of ends.
>  Is there any way I can do this short of calling the module at program end with 
> a code to have it manualy close the cursor?
>
>  TIA,
>
>
>
> Jeff Young
> Sr. Programmer Analyst
> Dynax Solutions, Inc.
> A wholly owned subsidiary of enherent Corp.
> IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2
> IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer 
> V5R3
> IBM  Certified Specialist- e(logo)server i5Series Technical Solutions 
> Implementer V5R3
>
>
>
>
>
>
>
>
>
>
>
>
> ---------------------------------
> Feel free to call! Free PC-to-PC calls. Low rates on PC-to-Phone.  Get Yahoo! 
> Messenger with Voice
> --
> This is the RPG programming on the AS400 / iSeries (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.