RE: SQLRPGLE cursor can't see update in file -- RPG400-L

Subject: RE: SQLRPGLE cursor can't see update in file
From: "Morgan, Paul" <Paul.Morgan@xxxxxxxxxxx>
Date: Mon, 30 Aug 2010 10:33:11 -0400
List-archive: <http://archive.midrange.com/rpg400-l>
List-help: <mailto:rpg400-l-request@midrange.com?subject=help>
List-id: RPG programming on the IBM i / System i <rpg400-l.midrange.com>
List-post: <mailto:rpg400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=unsubscribe>

Marc-Andre,

Maybe SET OPTION ALWBLK=*NONE will fix the problem? This prevents SQL reads(SELECT) from being blocked so you always get current values but it will hurt retrieval performance.

Paul

Principal Programmer Analyst
IS Supply Chain/Replenishment

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Marc Andre Gagnon
Sent: Monday, August 30, 2010 10:11 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQLRPGLE cursor can't see update in file

Hi

I use a SQLRPGLE program to display a file. when a user change information of the file my SQLRPGLE program still see the old value !!!!!

How i can see the new values whitout close the cursor ?

Marc-AndrÃ Gagnon

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.