× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



+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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.