I did remember DBU forgot about both WRKDBF and FEU.
I use the SQL update I don't like to.
Issue is we have non-technical types using DFU, I don't like it but they
have been doing it since the 80's-90's. It was much easier to show them
DFU than to write a program. If it goes away, will need to do something
else, not sure teaching them SQL is a good idea. What should be done is a
program to do the updates needed, I know that is what auditors would want.

On Fri, Apr 11, 2025 at 12:57 PM Vern Hamberg via RPG400-L <
rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi Sam

I'm not sure what you mean about update capabilities - we've been able
to use the *for update only* clause on *SELECT* statements for some time
- I don't know if that was added for use in ACS RSS only, or for other
reasons.

*Regards*

*Vern Hamberg*

IBM Champion 2025 <cid:part1.e0DOl1i7.m4Dhj5wL@centurylink.net> CAAC
(COMMON Americas Advisory Council) IBM Influencer 2023

On 4/11/2025 12:41 PM, Sam_L wrote:
In a former life I used FEU - File Edit Utility.

See https://www.alcsoftware.com/feu/.

And there is also WRKDBF

https://www.wrkdbf.com/


Neither are free. But isn't ACS SQL support now allowing update
capabilities.


Sam

On 4/11/2025 10:49 AM, DEnglander--- via RPG400-L wrote:
The only one I know of is DBU from PRODATA, www.dodbu.com

Doug

--
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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.