Re: Records written not seen by called program

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Scott,

Although I approve of the use of BLOCK(*NO) in order to avoid any
ambiguities, a "hidden" advantage of using Input-Add instead of Output is
that the table fields get defined in the I-Spec. Something quite handy if
you are not using things like EXTDESC.


Regards,

Luis

On Tue, Dec 6, 2016 at 5:04 PM Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

> Good point Scott...
>
> I should have made that clear.
>
> Charles
>
> On Tue, Dec 6, 2016 at 1:39 PM, Scott Klement <midrange-l@xxxxxxxxxxxxxxxx
> >
> wrote:
>
> > Hmm...
> >
> > Not sure that FEOD(N) is the "best" in all cases.   If you are writing a
> > bunch of records before doing the call, then I suspect FEOD(N) is the
> most
> > efficient because it still uses the "buffer" for performance, it just
> > flushes it at the right time.
> >
> > If you're only writing one record before calling the other program, then
> > I'd thinking adding BLOCK(*NO) to the DCL-F (or F-spec) would be more
> > efficient.  There's no value to record blocking if you're going to run
> feod
> > after every record.  BLOCK(*NO) turns it off.
> >
> > At any rate, I agree not to use FRCRATIO(1), that will not perform as
> > well.  Similarly using FEOD without the (N) will also perform worse.
> >
> > -SK
> >
> >
> >
> > On 12/6/2016 1:55 PM, Charles Wilt wrote:
> >
> > > having a unique key disables the buffering RPG does, since the DB has to
> > > know about the record to enforce uniqueness; which has performance
> > > implications.
> > >
> > > FRCRATIO(1) disables the RPG buffering along with the DB "buffering"
> > > inherit to single level store by forcing a write all the way to disk;
> > > which
> > > of course has even bigger performance implications.
> > >
> > > The "best" way to solve the issue is to use FEOD(N).
> > >
> > > Charles
> > >
> > > On Tue, Dec 6, 2016 at 12:38 PM, Roger Harman <roger.harman@xxxxxxxxxxx
> >
> > > wrote:
> > >
> > > Thanks.  I considered FEOD, but may not be able to modify the caller so
> > > > quickly.
> > > >
> > > >
> > > > Still hoping to confirm the dirty record issue vs unique key.
> > > >
> > > >
> > > > Roger Harman
> > > >
> > > > COMMON Certified Application Developer - ILE RPG on IBM i on Power
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > ________________________________
> > > > From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> on behalf of
> Charles
> > > > Wilt <charles.wilt@xxxxxxxxx>
> > > > Sent: Tuesday, December 6, 2016 11:30 AM
> > > > To: Midrange Systems Technical Discussion
> > > > Subject: Re: Records written not seen by called program
> > > >
> > > > FRCRATIO(1)  is a bad old idea...
> > > >
> > > > Add a FEOD(N) before calling PGMB.  That will flush RPG's buffer....
> > > >
> > > > Charles
> > > >
> > > >
> > > > On Tue, Dec 6, 2016 at 12:07 PM, Roger Harman <
> roger.harman@xxxxxxxxxxx>
> > > > wrote:
> > > >
> > > > I have a process that has failed a couple of times.  PgmA writes a
> record
> > > > > and then calls PgmB with they key info.  On rare occasions, the chain
> to
> > > > > the file from PgmB fails.
> > > > >
> > > > > The file in question is not unique keyed and I'm wondering if the
> record
> > > > > is being buffered and not visible to the called program.  I recall
> > > > reading
> > > >
> > > > > something about that a long time ago and that the fix is to have a
> > > > > unique
> > > > > key (LF?) over the physical file.  Is that correct?  Is FRCRATIO(1)
> > > > > essentially the same thing?  It's not a high volume process.  Maybe
> > > > 12,000
> > > >
> > > > > records on a busy day.
> > > > >
> > > > > Thoughts?
> > > > >
> > > > > Thank you.
> > > > >
> > > > > Roger Harman
> > > > > COMMON Certified Application Developer - ILE RPG on IBM i on Power
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > > > list
> > > >
> > > > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > > > To subscribe, unsubscribe, or change list options,
> > > > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > > [http://lists.midrange.com/images/small-family.gif]<http:
> > > > //lists.midrange.com/mailman/listinfo/midrange-l>
> > > >
> > > > MIDRANGE-L Info Page<http://lists.midrange.com
> > > > /mailman/listinfo/midrange-l
> > > >
> > > > > lists.midrange.com
> > > > To unsubscribe from MIDRANGE-L, get a password reminder, or change your
> > > > subscription options enter your subscription email address:
> > > >
> > > >
> > > >
> > > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > > > Before posting, please take a moment to review the archives
> > > > > at http://archive.midrange.com/midrange-l.
> > > > midrange.com -- MIDRANGE-L mailing list archive<http://archive.
> > > > midrange.com/midrange-l>
> > > > archive.midrange.com
> > > > midrange.com MIDRANGE-L mailing list archive
> > > >
> > > >
> > > >
> > > >
> > > > > Please contact support@xxxxxxxxxxxx for any subscription related
> > > > > questions.
> > > > >
> > > > > Help support midrange.com by shopping at amazon.com with our
> affiliate
> > > > > link: http://amzn.to/2dEadiD
> > > > [http://g-ec2.images-amazon.com/images/G/01/social/api-
> > > > share/amazon_logo_500500._V323939215_.png]<http://amzn.to/2dEadiD>
> > > >
> > > > Amazon.com: Online Shopping for Electronics, Apparel, Computers, Books,
> > > > DVDs & more<http://amzn.to/2dEadiD>
> > > > amzn.to
> > > > Online shopping from the earth's biggest selection of books, magazines,
> > > > music, DVDs, videos, electronics, computers, software, apparel &
> > > > accessories, shoes, jewelry, tools & hardware, housewares, furniture,
> > > > sporting goods, beauty & personal care, broadband & dsl, gourmet food &
> > > > just about anything else.
> > > >
> > > >
> > > >
> > > >
> > > > > --
> > > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > > > list
> > > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > > To subscribe, unsubscribe, or change list options,
> > > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > > [http://lists.midrange.com/images/small-family.gif]<http:
> > > > //lists.midrange.com/mailman/listinfo/midrange-l>
> > > >
> > > > MIDRANGE-L Info Page<http://lists.midrange.com
> > > > /mailman/listinfo/midrange-l
> > > >
> > > > > lists.midrange.com
> > > > To unsubscribe from MIDRANGE-L, get a password reminder, or change your
> > > > subscription options enter your subscription email address:
> > > >
> > > >
> > > >
> > > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > > Before posting, please take a moment to review the archives
> > > > at http://archive.midrange.com/midrange-l.
> > > > midrange.com -- MIDRANGE-L mailing list archive<http://archive.
> > > > midrange.com/midrange-l>
> > > > archive.midrange.com
> > > > midrange.com MIDRANGE-L mailing list archive
> > > >
> > > >
> > > >
> > > >
> > > > Please contact support@xxxxxxxxxxxx for any subscription related
> > > > questions.
> > > >
> > > > Help support midrange.com by shopping at amazon.com with our affiliate
> > > > link: http://amzn.to/2dEadiD
> > > > [http://g-ec2.images-amazon.com/images/G/01/social/api-
> > > > share/amazon_logo_500500._V323939215_.png]<http://amzn.to/2dEadiD>
> > > >
> > > > Amazon.com: Online Shopping for Electronics, Apparel, Computers, Books,
> > > > DVDs & more<http://amzn.to/2dEadiD>
> > > > amzn.to
> > > > Online shopping from the earth's biggest selection of books, magazines,
> > > > music, DVDs, videos, electronics, computers, software, apparel &
> > > > accessories, shoes, jewelry, tools & hardware, housewares, furniture,
> > > > sporting goods, beauty & personal care, broadband & dsl, gourmet food &
> > > > just about anything else.
> > > >
> > > >
> > > >
> > > > --
> > > > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > > > list
> > > > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > > > To subscribe, unsubscribe, or change list options,
> > > > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > > > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > > > Before posting, please take a moment to review the archives
> > > > at http://archive.midrange.com/midrange-l.
> > > >
> > > > Please contact support@xxxxxxxxxxxx for any subscription related
> > > > questions.
> > > >
> > > > Help support midrange.com by shopping at amazon.com with our affiliate
> > > > link: http://amzn.to/2dEadiD
> > > >
> > > > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: http://amzn.to/2dEadiD
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD