Re: Question about Cursors - SQLRPGLE

[Joep Beckeringh <joep@xxxxxxxxxxxxxxxxxxx>]

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