RE: RPG Stored Procedure leaving files locked

If the SQL update is done via cursor, have you compiled to
CLOSQLCSR(*ENDMOD) or set option CLOSQLCSR=*ENDMOD in the program? 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
THarteau@xxxxxxxxxxxxxxxxxx
Sent: Friday, October 21, 2005 1:01 PM
To: RPG programming on the AS400 / iSeries
Subject: RPG Stored Procedure leaving files locked


Hi,
      I have an RPG program defined as a stored procedure. It has one
SQL update and the other files are input full.  These files are
remaining locked after the program ends. I have tried to seton LR. I
have put one of the files under USROPN and done an OPEN and CLOSE, and
even put in CLOSE *ALL.  I am doing this before the return but
eventually want to trigger it on receiving a code on the last record.  I
tried compiling with COMMIT *NONE.  Any ideas how to unlock these files?

<===================================================>

Terri Harteau
Felker Brothers Corporation
****************
"The happiest people don't necessarily have the best of everything.
They just make the best of everything!"
****************




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