Re: When WRITE doesn't Write

+1
You can also just issue

    OVRDBF ... FRCRATIO(1)  

for testing and debugging purposes, rather than changing the physical file permanently. That way, the effect is limited to just your job, until you close the file and issue DLTOVR.

As Charles suggests, using FRCRATIO(1) on physical files can severely impact performance of IBMi.


On Wednesday, February 20, 2019, 11:15:47 AM EST, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

for anyone thinking about using this...be sure your understand the
performance implications...which are very, very bad...

FEOD(n)

Inside the RPG program will flush the RPG buffer to the DB without forcing
the DB to write to disk as FRCRATIO(1) does..

Charles


On Tue, Feb 19, 2019 at 11:15 PM Magne Kofoed <magne.kofoed@xxxxxxxxx>
wrote:

Hi,
try chgpf file(xxxx)  FRCRATIO(1)
The records will be written to the file immediately
Will not wait until the job is finished - as it seems to be the result
here.

Magne

Den ons. 20. feb. 2019 kl. 07:02 skrev Jonathan Ball <jonball52@xxxxxxxxx

:

On 2/19/2019 9:50 AM, mlazarus wrote:

Terri,

  Do you have commitment control started for this file?

That was my first thought as well.  Could be wrong, though, because Terri
eventually reported that it's now working.

You might need to commit the transaction.  If not, as a test, add FEOD
right after the write.  Then see if it shows up.

  -mark

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com