RE: Question about Cursors - SQLRPGLE

["Holden Tommy" <Tommy.Holden@xxxxxxxxxxxxxxxxx>]

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



DISCLAIMER:
This email (including any attachments) is intended for the sole use of
the intended recipient/s and may contain material that is CONFIDENTIAL
AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying or distribution or forwarding of any or all of the contents in
this message is STRICTLY PROHIBITED. If you are not the intended
recipient, please contact the sender by email and delete all copies;
your cooperation in this regard is appreciated.
--
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.