I would not have thought that a delete trigger would prevent a clear of a
PF.
Who knew?:)
Paul Therrien
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of sjl
Sent: Tuesday, May 22, 2012 9:23 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: Trigger program may stop the upload operation from PC to AS400?
Gavin -
[Since this is not specifically RPG related, this question should have been
posted to the Midrange-L mailing list...]
Are you attempting to replace the file with your upload?
You cannot clear a file which has a delete trigger on it, which is what
happens internally when an upload replaces the data in the file:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=%2Fdbp
%2Frbaforzahftrq.htm
[...]
Clear Physical File Member (CLRPFM)
a.. If the physical file is associated with a delete trigger, the CLRPFM
operation fails.
[...]
- sjl
Gavin wrote:
Hi, All
Currently I have a PF file SPMAST connecting to a trigger program TRSPMASTR
on *BEFORE *DELETE, the problem is I can't use the PC -> AS400 tool to
upload this file (update selection is override current member), and it works
while I remove the trigger on SPMAST.
I have another file IVMAST triggered on *AFTER *UPDATE condition and PC ->
AS400 works on this file. The question is triggered PF on *BEFORE *DELETE
can't be upload by PC -> AS400 tool?
Thanks & Regards
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
