MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » April 2014

Re: Issue reading from a member in SQL



fixed

Nope, the RPG program buffer (aka blocking) is specific to the program/file
(f-spec)

So even if you have the same physical file defined with two different
f-specs (one OUTPUT one INPUT) the program can't see data in the OUTPUT
buffer when reading via INPUT.

Perhaps you're thinking of the "buffering" done by the DB itself. A write
to the DB stays in memory, it doesn't (usually) go straight to the disk.
That data can be seen by other programs.

more info:
http://www-01.ibm.com/support/docview.wss?uid=nas8N1018493

Make sure to use FEOD(N)...that flushes the RPG program buffer to the DB
without forcing the DB to flush to disk. Much better performance than the
straight FEOD which flushes all the way to disk.

Charles



On Tue, Apr 15, 2014 at 12:53 PM, Darryl Freinkel <
dfreinkel@xxxxxxxxxxxxxxxxx> wrote:

I have commitment control turned off and am using commit(*none).

I see the writes are not written in SQL so I will add the FOED and check
the results.

I thought records in the buffer were supposed to be able to be read by the
programs in the job?

Thanks

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
--
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.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact