For SQL created tables, to provide the same effect as the allow update or
allow delete on the DDS create, you can just add triggers, before update
and before delete and even before insert. The trigger can just do a signal
and can thus stop updates, deletes or even writes. The trigger can be
applied after the data is fixed in the file.
eduard@xxxxxxxxxxxxxxxxxxxxxxx wrote:
Does anyone know if there is such api?
I've searched quite a lot but could not find something that seems to have that
function.
Regards,
Eduard.
----- Original Message ----
From: Walden H. Leverich <WaldenL@xxxxxxxxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, May 29, 2007 12:53:41 PM
Subject: RE: AW: Can I create an ALWUPD/ALWDLT *No file with embeded SQL?
I really need the ALWUPD/ALWDLT features.
I believe (but won't bet on it) that there's an API that will set those
flags on a file too. Perhaps the APIs could be used on a table? I would
think so.
-Walden
--
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com
Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
--
"Suppose you were an idiot...
And suppose you were a member of Congress...
But I repeat myself."
- Mark Twain
===========================================================
R Bruce Hoffman
midrange.com
