RE: Question about Cursors - SQLRPGLE

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

You could try adding one of the following to the statement.

With nc = no commit
With ur = uncommitted read
With cs = Cursor Stability 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Monday, October 31, 2005 3:30 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Question about Cursors - SQLRPGLE

Developers here have added RCLRSC to GDMENU2C and that seems to do it.
I consider that a "workaround".  I would be interested in how I should
have coded the SQL application to not have to do this.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





rob@xxxxxxxxx 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
10/31/2005 02:08 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
RE: Question about Cursors - SQLRPGLE






It wasn't a explicit cursor statement.  I posted the whole SQL
statement.

There was another sql section in that same program involving an explicit

SQL cursor against a different file.  But that one works fine and the
lock 

is removed.

Rob Berendt