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
      FROM
      [ftp://MyUserId:MyPassword@unummvs3.unum.com/MyPassword@unummvs3.unum.com/"'TEST.USRA.OMIS.CALLCNT.PRN'"]
      (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?

       

      James