I'm not an AS400 person and don't need to become one! However, I do need to get some data off of an AS400 and onto a Windows PC for the purpose of writing a program that will parse the data files retrieved and "convert" them to something else (sql server, in this case).
I was able to successfully FTP from the AS400 to my FTP server. I could browse contents and navigate the dir structure of the ftp server from the 400 after being logged in.
I could "PUT" a data file to the ftp server and a file with an identical name would appear there. However it would always contain zero bytes.
If I transferred a program file (as identified by the AS400 technicians there), it would be greater than zero bytes.
I tried toggling the transfer "mode" from active to passive (and vice-versa). I tried transferring in Binary mode, ASCII mode, Image (same as binary) mode. I did these in all possible combinations of each. No dice...still zero bytes on data files, more than zero bytes on program files.
1) How can I transfer data files in a batch (for instance, get the entire library's contents) so that the data within the file actually transfers also
2) Is FTP'ing files from the AS400 the best (or even acceptable) way to get data out of the 400 for conversion for use in Windows (SQL server or MS Access, for instance)?