View Full Version : FTP to AS/400 triggered file
03-28-2002, 06:45 AM
Frank, I wonder if Append would work better? Bill > I have a .bat file which executes an FTP to 2 files. One has numerous records, the other has one record and goes to a triggered file to execute a process > The "PUT" to the trigger file gets the following error: > 426-Cannot write to member (membername) in file (filename) in library (libraryname) > > If i remove the trigger on the file, the one record transfers successfully.
03-28-2002, 12:59 PM
frankmc wrote: "If i remove the trigger on the file, the one record transfers successfully." Not being able to FTP or do a CPYF to a AS/400 triggered file was an issue for us, too. Turning the trigger off or FTP'ing to another file and then RPG DELETing and WRITEing or SQL INSERTing re the only options obvious to me. Ralph
03-28-2002, 05:57 PM
I cam across such a problem 4 months back. My requirement was remote system A will FTP a file to my AS400 system ( say B). After successful FTP a program should fire in B. I wrote an after insert trigger program on my file. I also came across the fact that trigger would go at every row as an FTP is a full delete followed by a row by row insert. I used counters to prevent trigger from firing until the end. All these efforts went a vain coz trigger on the file on system B will not allow ftp from SYSTEM A. My colleague here who works extensively on NT did this job on NT machine in just 2 hours. For as400 , I could gather that I had to write exit programs for FTP which we here have never done before. Finally as a solution , we did the fol... SYSTEM A will ftp the file to my as400 system B.After successful ftp , system A will send me a message thru socket programs in C. We have a home grown MQ Series like software for this. On receipt of the message, my as400 program will start reading the new file. Obviously , I did not give u all any suggestions but the vainless efforts I put during those days, I could not resist to share. Santosh.
03-28-2002, 06:28 PM
Santosh wrote: "Obviously , I did not give u all any suggestions but the vainless efforts I put during those days, I could not resist to share." We feel your pain, Santosh. Thanks. Ralph
04-19-2002, 09:35 AM
Have you checked the libl of the user profile that you are using in the FTP? Most likely you have done that already, but I thought that I would ask. Bryan
04-19-2002, 07:38 PM
The problem is simple... If u ftp a file from remote system to AS400 and the AS400 file has a trigger, it will not allow ftp. If u remove the trigger from as400 file and now ftp "put" from remote system , it lets u write the file. Alll other things remain the same i.e... file type ,file name , authority, user profile, libl list etc etc... Is there a way to ftp in such a condition ?????It will be a great help to me if the ans is YES.
04-24-2002, 12:34 PM
What i am missing here? I have a .bat file which executes an FTP to 2 files. One has numerous records, the other has one record and goes to a triggered file to execute a process The "PUT" to the trigger file gets the following error: 426-Cannot write to member (membername) in file (filename) in library (libraryname) If i remove the trigger on the file, the one record transfers successfully. The .bat file is simply: an open, username, password, ASCII, CD libraryname, put statement 1, put statement 2, quit
04-24-2002, 12:34 PM
I assume you want the AS/400 to do something once the data arrives. Have you thought about using ftp to send the desired command string to the AS/400 after the put statement. I think the command is QUOTE RUNCMD or something like that.
Powered by vBulletin® Version 4.1.5 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.