Databases
StackOverflow2013
Postsdbo
PODownloading text files with Python and ftplib.FTP from z/os
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODownloading text files with Python and ftplib.FTP from z/os
    text
    copied!<p>I'm trying to automate downloading of some text files from a z/os PDS, using Python and ftplib.</p> <p>Since the host files are EBCDIC, I can't simply use FTP.retrbinary(). </p> <p>FTP.retrlines(), when used with open(file,w).writelines as its callback, doesn't, of course, provide EOLs.</p> <p>So, for starters, I've come up with this piece of code which "looks OK to me", but as I'm a relative Python noob, can anyone suggest a better approach? Obviously, to keep this question simple, this isn't the final, bells-and-whistles thing.</p> <p>Many thanks.</p> <pre><code>#!python.exe from ftplib import FTP class xfile (file): def writelineswitheol(self, sequence): for s in sequence: self.write(s+"\r\n") sess = FTP("zos.server.to.be", "myid", "mypassword") sess.sendcmd("site sbd=(IBM-1047,ISO8859-1)") sess.cwd("'FOO.BAR.PDS'") a = sess.nlst("RTB*") for i in a: sess.retrlines("RETR "+i, xfile(i, 'w').writelineswitheol) sess.quit() </code></pre> <p>Update: Python 3.0, platform is MingW under Windows XP.</p> <p>z/os PDSs have a fixed record structure, rather than relying on line endings as record separators. However, the z/os FTP server, when transmitting in text mode, provides the record endings, which retrlines() strips off. </p> <p><strong>Closing update:</strong></p> <p>Here's my revised solution, which will be the basis for ongoing development (removing built-in passwords, for example):</p> <pre><code>import ftplib import os from sys import exc_info sess = ftplib.FTP("undisclosed.server.com", "userid", "password") sess.sendcmd("site sbd=(IBM-1047,ISO8859-1)") for dir in ["ASM", "ASML", "ASMM", "C", "CPP", "DLLA", "DLLC", "DLMC", "GEN", "HDR", "MAC"]: sess.cwd("'ZLTALM.PREP.%s'" % dir) try: filelist = sess.nlst() except ftplib.error_perm as x: if (x.args[0][:3] != '550'): raise else: try: os.mkdir(dir) except: continue for hostfile in filelist: lines = [] sess.retrlines("RETR "+hostfile, lines.append) pcfile = open("%s/%s"% (dir,hostfile), 'w') for line in lines: pcfile.write(line+"\n") pcfile.close() print ("Done: " + dir) sess.quit() </code></pre> <p>My thanks to both John and Vinay</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload