I an running an SQR under PeopleSoft
PIA (Web) that is using call system to ftp a file from NT to the FTP site.
The code works fine if I run it through SQRW, but when running it through a
PeopleSoft page, nothing happens. I don't believe I am getting a valid status
code either, as it is always 0, though from what I read in the SQR manuals,
for NT, anything less than 32 is an error.
any help would be appreciated
I would pipe the output of the FTP command to a log file. That way you at least have something to review in the case of problems. We use SQR to perform all of our file transfers to a wide variety of servers. This method has proven quite reliable for us.
In addition, we wrote some code to spin through the log file and look for precise reasons for failure (invalid password, simply not connected, etc.).