Re: Writing records to database.

[Scott Klement <klemscot@xxxxxxxxxxxx>]

No!  Please DO NOT use CHGPF or CHGLF to change FRCRATIO to 1.   You'll
make the file writes much slower, and by changing the file itself, you'll
slow down every single program that writes to it!!

Usually, the reason this comes up is that your program is calling another
program.   That new program needs to see the records, and cannot because
they haven't been written to disk.

The fix is simple.   Use the FEOD op-code on the file before calling the
program.  FEOD will force all records to the file, so that they can be
read.

If you only use FEOD when you need to (rather than with every write)
you'll still have a program that performs well -- and more importantly,
you won't impact the performance of every other program on the system.

If you MUST change the FRCRATIO, do it for your program ONLY using an
OVRDBF command... but again, I recommend FEOD instead.


On Tue, 1 Oct 2002, Raul A Jager wrote:

> use CHGPF or CHGLF and set   FRCRATIO to 1
>
> >I am trying to write a record to the database file through RPGIV pgm.
> >Though the write is successfull , I am not able to see the records in
> >the file as long as the program is active.
> >
> >Once the program is terminated I am able to see the record written.
> >
> >I am not able to find the reason for this , The file is not journalled
> >& it is not open in the commit mode in the pgm.
> >
> >Can anyone please let me know the reason for this.
> >
> >Thanks in advance
> >Vishnu
> >