Re: Writing records to database.

Shouldn't one be careful using FRCRATIO 1, as it will affect performance in
batch programs , as it excludes the use of "record blocking" by the system



                      Raul A Jager
                      <raul@abc.com.py>        To:       rpg400-l@midrange.com
                      Sent by:                 cc:       (bcc: Deon 
Fourie/Notes)
                      rpg400-l-admin@mi        Fax to:
                      drange.com               Subject:  Re: Writing records to 
database.


                      10/01/02 02:11 PM
                      Please respond to
                      rpg400-l






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
>
>_______________________________________________
>This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
>To post a message email: RPG400-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
>or email: RPG400-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/rpg400-l.
>
>

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.