RE: Question about Cursors - SQLRPGLE

Nice to know...I'll keep that in mind but I have never had that
particular issue arise. 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Joep Beckeringh
Sent: Wednesday, October 26, 2005 1:23 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Question about Cursors - SQLRPGLE

Tommy and Satheesh,

But even then the SQL engine sometimes still holds a lock on the file. 
It can be released with ALCOBJ OBJ(xxx) CONFLICT(*RQSRLS).

Joep Beckeringh


Holden Tommy wrote:
> Set option CLOSQLCSR=*ENDMOD or compile with CLOSQLCSR *ENDMOD  I 
> think the default is *ENDACTGRP.
> 
> 
> Thanks,
> Tommy Holden
> 
> 
> -----Original Message-----
> From: rpg400-l-bounces+tommy.holden=hcahealthcare.com@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces+tommy.holden=hcahealthcare.com@xxxxxxxxxxxx] 
> On Behalf Of Satheeshkumar_selvaraj
> Sent: Tuesday, October 25, 2005 11:42 AM
> To: RPG programming on the AS400 / iSeries
> Subject: Question about Cursors - SQLRPGLE
> 
> Hi All,
> 
>  
> 
> I am using cursor in my SQLRPGLE program.
> 
> I found that even after coming out of the program the file used in the

> cursor holds the lock.
> 
> I am using CLOSE cursor statement in my program.
> 
> Is there any way to release this lock when the program ends? (in the 
> program itself).
> 
>  
> 
> -Satheesh

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