Re: FRCRATIO issue

FRCRATIO would apply to SQL operations also...

FEOD(n) is RPG specific
FEOD without the N is a request to the OS..somewhat comparable to FRCRATIO,
except the flush to disk is under the programs control.

SQL doesn't need FEOD(n) and doesn't support anything like FEOD.

Charles

On Mon, Nov 15, 2021 at 3:44 PM <dfreinkel@xxxxxxxxxxxxxxxxx> wrote:

I have not used FRCRATIO or FOED for years. How do you do that with SQL
UPDATES, WRITES and DELETES?

Darryl Freinkel
A4G
Telephone: 770.321.8562 Mobile: 678.355.8562

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Charles
Wilt
Sent: Monday, November 15, 2021 4:19 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: FRCRATIO issue

I second FEOD(N)..

Additionally, I'll say that FRCRATIO(1) is never the right answer
now-a-days...

Lastly, if the submitted web programs are truely done, ie. those jobs have
ended. Then there shouldn't be any reason not to see the records
regardless
of FRCRATIO() or the use of FEOD(N).

Charles

On Mon, Nov 15, 2021 at 11:08 AM (WalzCraft) Jerry Forss <
JForss@xxxxxxxxxxxxx> wrote:

Hi All,

I have pgm (A) that submits a another pgm (B).
Pgm B in turn submits a dozen web service pgms to run concurrently
that all have the OVRDBF FILE(ShpRates) TOFILE(ShpRates) FRCRATIO(1) .
Pgm B waits until all the web service pgms are finished and then calls
a print pgm.

The issue is that the print pgm does not find all the records in

ShpRates.

If I run the print pgm seperatly it prints all the records.

Why is the FRCRATIO not working as expected?
What am I missing?

Thanks!



Subject to Change Notice:

WalzCraft reserves the right to improve designs, and to change
specifications without notice.

Confidentiality Notice:

This message and any attachments may contain confidential and
privileged information that is protected by law. The information
contained herein is transmitted for the sole use of the intended

recipient(s) and should "only"

pertain to "WalzCraft" company matters. If you are not the intended
recipient or designated agent of the recipient of such information,
you are hereby notified that any use, dissemination, copying or
retention of this email or the information contained herein is
strictly prohibited and may subject you to penalties under federal
and/or state law. If you received this email in error, please notify
the sender immediately and permanently delete this email. Thank You

WalzCraft PO Box 1748 La Crosse, WI, 54602-1748
www.walzcraft.com<http://www.walzcraft.com> Phone: 1-800-237-1326
--
This is the RPG programming on IBM i (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@xxxxxxxxxxxxxxxxxxxx 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 IBM i (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@xxxxxxxxxxxxxxxxxxxx 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 IBM i (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@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com