Equivalent to FEOD in SQL -- RPG400-L

Subject: Equivalent to FEOD in SQL
From: Paul Bailey <PabloMotte+Midrange@xxxxxxxxx>
Date: Tue, 6 Oct 2020 14:44:48 +0100
List-archive: <https://archive.midrange.com/rpg400-l/>
List-help: <mailto:rpg400-l-request@lists.midrange.com?subject=help>
List-id: RPG programming on IBM i <rpg400-l.lists.midrange.com>
List-post: <mailto:rpg400-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/rpg400-l>, <mailto:rpg400-l-request@lists.midrange.com?subject=unsubscribe>

We require the FEOD op code at times to force the RPG data writes to finish
before we call an additional routine to process that data.

When using embedded SQL I am having to write a few seconds pause in RPG
before calling the next routine to ensure the data has been written because
FEOD does not appear to work on SQL written data, but this is not ideal and
seems like a poor workaround.

Is there an equivalent to FEOD when the data has been written by embedded
SQL statements in an SQLRPGLE program?

TIA

-Paul/

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Equivalent to FEOD in SQL , Charles Wilt

This mailing list archive is Copyright 1997-2025 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.