Re: Persistent File Locks when using SQLRPGLE for Neverending Programs

Do you have a cursor? if so close it before going to sleep.

Also will adding "for read only" help in your situation?

example
select * from file for read only


--

Michael Schutte
Admin Professional



Try Bob Evans GRILLING SAUSAGE! This summerâs hottest destination is your
own backyard with Bob Evans Brats and Italian Sausage! For tasty recipes
using Bob Evans grilling sausage, visit http://www.BobEvans.com/Recipes



rpg400-l-bounces@xxxxxxxxxxxx wrote on 07/07/2009 04:23:47 PM:

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.