Re: Writing records to database.

FRCRATIO is the number of records that can be added or updated before
forcing the write to disk.  I usualy leave the default, but when I need
to make sure that the next read finds the newly added record I set it to
1.  It is a balance between performance and reliable reading.
You can also change it in an OVRDBF, so you will not loose performance
when you don't need to force inmediate writing.
____________________________________________________________________________________________________
Arulanandham_R wrote:

what is that FRCRATIO???

Live each and every second
And don't forget to smile

-----Original Message-----
From:	Raul A Jager [SMTP:raul@abc.com.py]
Sent:	Tuesday, October 01, 2002 5:42 PM
To:	rpg400-l@midrange.com
Subject:	Re: Writing records to database.

use CHGPF or CHGLF and set   FRCRATIO to 1
_____________________________________________________
Vishnu Rao (RBIN/DBA-EMS) * wrote:

Hi,

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