As was pointed out in other responses, when you are trying to do a *REPLACE the trigger program causes the upload to fail.
Disable the trigger; do the upload; then enable the trigger again.
Paul Therrien
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Gavin Fung
Sent: Wednesday, May 23, 2012 8:58 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Trigger program may stop the upload operation from PC to AS400?
The error message means like "transfer function will be terminated", try again then error PCSFT999 pops up - During the transfer request, detected an unexpected error. There is a *Advanced *option in PC -> AS/400 utility,
3 options for me to decide how to create the AS/400 objects:
1.Yes, create member
2.Yes, create file and member
3.No. replace current member
If your *REPLACE means the option 3, that was the option I selected. The trigger program works fine, cause I found it can't be cleared neither by SQL nor CLRPFM as sjl mentioned.
Gavin
-----
date: Tue, 22 May 2012 21:23:36 -0500
from: <paultherrien@xxxxxxxxxxxxxxxxxx>
subject: RE: Trigger program may stop the upload operation from PC to
AS400?
What errors are you getting?
An upload of data should not trigger a delete ... unless you are uploading with *REPLACE?
My gut thought was a library list issue? Is the trigger program in your library list and is the trigger on the file specified with *LIBL?
Paul Therrien
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Gavin Fung
Sent: Tuesday, May 22, 2012 8:26 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Trigger program may stop the upload operation from PC to AS400?
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
