|
date: Mon, 2 Nov 2015 15:48:12 -0800
from: Roger Harman <roger.harman@xxxxxxxxxxx>
subject: SQL Check If File Exists (via RPG)
I have a situation where I need to update/add/delete records in a
historical snapshot file (or files) if the current live file is changed
(retro-active changes).?
The historical files are named by year/month and may or may not exist for
a?selected?record.
Looking for suggestions on the quickest easiest way to verify a file's
existence. ?This will be in a trigger program.
Thanks.
Roger Harman
COMMON Certified Application Developer ? ILE RPG on IBM i on Power
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.