Re: Persistent File Locks when using SQLRPGLE for Neverending Programs

If you close the cursor, SQL should release lock if something else needs.

Otherwise, code a CL module (CLLE), make the program a nomain procedure and
call the procedure from the CL using CALLPRC and compile the module for
CLOSSQLCSR(*ENDMOD). When it exits it will close the cursors but you should
not have to do that if you are closing the cursor. The os should release
them if anybody else needs them.

On Tue, Jul 7, 2009 at 2:40 PM, DeLong, Eric <EDeLong@xxxxxxxxxxxxxxx>wrote:

Compile your NEP to use ACTGRP(*NEW)... SQL Set Option CLOSQLCSR =
*ENDACTGRP

-Eric

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Rick DuVall
Sent: Tuesday, July 07, 2009 3:24 PM
To: RPG400-L@midrange. com
Subject: Persistent File Locks when using SQLRPGLE for Neverending
Programs

Hi everybody,

I have a number of NEPs that used to

1. Open files
2. perform all processing
3. Close files
4. Sleep for x minutes
5. repeat.

Since we have begun using sql, these programs maintain file locks, on
those
files opened by SQL, while sleeping.

Since the program is not run by a CL wrapper, there appears to be no
clear way to relinquish the locks during the sleep period. The only
SQL option that appears to apply is the CloSqlCsr and it only
supports
*ENDMOD or *ENDACTGRP neither of which ever occur. Am I missing
something?

Thanks!


--
Best regards,
Rick

Systems Manager
Dealer's Auto Auction of Okc
1028 S. Portland
Oklahoma City, OK 73108
(405) 947-2886
mailto:rick@xxxxxxxxxx
http://www.nothingisreal.com/dfki/no-word

--
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.



--
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.