RE: SQL Closing Files

[Gaetano Bordin <gaetano.bordin@xxxxxxxxx>]

Have a look at "soft-close" SQL enhancement.
Il 26/dic/2013 16:39 "Gary Thompson" <gthompson@xxxxxxxxxxx> ha scritto:

> Jay,
>
> I have no experience with CGIDEV2.
>
> But, I had problems with open files where I had
> embedded sql running in the default activation group.
>
> Don't remember all details, but that was a: Bad idea.
>
> The solution was to re-compile the app to run in a named activation group.
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of tegger@xxxxxxxxxxx
> Sent: Thursday, December 26, 2013 8:23 AM
> To: RPG programming on the IBM i (AS/400 and iSeries)
> Subject: SQL Closing Files
>
> I have a couple of programs that are RPG/CGI with embedded SQL using
> CGIDEV2 that are not closing files. The *INLR is on and each SQL block has
> the exec sql close statements. But the files are still being left open.
>
> Anyone else seeing this??
>
>
> Jay B
> Delaware
>
> --
> This is the RPG programming on the IBM i (AS/400 and 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.
>
> --
> This is the RPG programming on the IBM i (AS/400 and 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.