Hello all...
I received a couple of posts that immediately triggered some memory
details concerning the "Reuse Deleted Records" flag, which was set to Yes,
and which basically takes the Arrival order sequencing and tosses it out
the window.
We took that flag off the file and it's running exactly as it should.
Have a good day.
Blake Moorcroft
Analyst/Programmer - Corporate
Farrow
2001 Huron Church Road, PO Box 333, Windsor, Ontario N9A 2L6
Bus: 519-966-3003 ext. 566
blake.moorcroft@xxxxxxxxxx
From: CRPence <crpbottle@xxxxxxxxx>
To: rpg400-l@xxxxxxxxxxxx
Date: 09/21/2015 05:50 PM
Subject: Re: Writing to Arrival Sequence file - not working
properly
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>
On 21-Sep-2015 14:19 -0600, Cornelia F Meyer wrote:
Check the FRCRATIO for the physical. If you want the records to be
written immediately you need to change it to 1 (one) or you can use
OVRDBF to change the value before calling the program.
The Force Ratio is unrelated to the record ordering.
Besides, use of the FRCRATIO(1) should be avoided, generally, and
journaling used instead; actually, should be avoided with any
specification other than the *NONE, with a meaning of "let the system
decide". Such misuse of the FRCRATIO often gives rise to
poorly-performing writes. Often the misuse is a heavy-handed means to
effect what is wanted, but without fully understanding by the programmer
of the true consequences and underlying effect. Whenever contemplating
use of the FRCRATIO for the perceived effects, consider instead the use
of either the Force End Of Data (FEOD) capability or the BLOCK(*NO)
file-declaration specification; those features are likely to enable the
desired effect, without the consequences\effects of what the
small-values specification for Force Ratio actually implements\intends.
As an Amazon Associate we earn from qualifying purchases.