1 Reply Latest reply: Jul 17, 2012 7:24 PM by Rob Wunderlich RSS

    How to FTP from z/OS mainframe?

    James Carpenter

      I need the load script to read a text file via the FTP server on a mainframe running z/OS. I can connect to the server using the wizard and see files in the server's directory tree, but I need to retrieve a file from the MVS file system, not the FTP (Unix?) file system, if I'm explaining this correctly.


      I adapted the script wizard's code thus, but it errors out saying "Cannot open file":


      LOAD @1
      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);



      I have confirmed that the FTP server is working by successfully using a SAS program to read an MVS file from it. Unfortunately the SAS syntax is very different from QlikView's. Does anyone have suggestions for this?