After you display the results, and if you have the server mapped to a drive, you can simply use File\Save As to select the PC file type and browse to the mapped drive to create the file.
If you want to automate the process, or you do not want to display the results first, you need to create a script and use the EXECUTE command to create and FTP the results to the server. For example:
EXECUTE VIEW(VIEW/LIB) PCFMT(*XLS) RECIPIENT('ftp:111.222.333.444/dir/filename.xls(userid/pwd)')
You must specify the address, folder (dir), and file name. You also need a valid user ID and password on the remote system.
Still have questions? We can help. Submit a case to Technical Support.