Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jcarpenter9
Contributor

How to FTP from z/OS mainframe?

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

Tags (4)
1 Reply
MVP & Luminary
MVP & Luminary

Re: How to FTP from z/OS mainframe?

Ran across this old thread in a search. The answer is you have to use a special directory name that indicates an MVS file vs Unix (the default) file. The name is set by your sysprog in the FTP server profile. The keyword is "MVSURLKEY". For example, if the value is set as follows:

MVSURLKEY MVSDS

ftp://MyUserId:MyPassword@unummvs3.unum.com/MyPassword@unummvs3.unum.com/MVSDS/'TEST.USRA.OMIS.CALLC...

-Rob

http://robwunderlich.com