Writing a Report › Tailor Reports Using Secondary Commands › How to Download CSV Formatted Reports

How to Download CSV Formatted Reports

Several ways exist to download generated CSV reports into a spreadsheet on a PC. You can store the report on your PC as a pure text file with the extension .CSV.

To download the report from the mainframe to your PC, use any of the following methods:

• (Recommended method) Use any suitable FTP client to download the report directly from the JES spool (if FTP access is enabled).
• Copy and paste the report from your terminal emulator into a text editor on your PC.
• Save the CSV report into a data set and do either of the following:
  • Use the function Download file from your terminal emulator (if it is supported).
  • Use any suitable FTP client to download the report (if FTP access to data sets is enabled).

Example: Download a CSV Formatted Report

The following example explains how to download a CSV report directly from the JES spool using Windows built-in command line FTP client. Usage is similar in different FTP clients. Bold text indicates commands that you must enter, variable parts are in italics.

C:\>ftp
ftp> open server.organization.com
Connected to server.organization.com.
220- IBM FTP CS V1R11 at SERVER.ORGANIZATION.COM, 11:11:11 on 2011-11-11.
220 Connection will close if idle for more than 11 minutes.
User (server.organization.com:(none)): username
331 Send password please.
Password: userpassword
230 USERNAME is logged on.  Working directory is "USERNAME.".
ftp> quote site filetype=jes
200 SITE command was accepted
ftp> quote site jesjobname=*
200 SITE command was accepted
ftp> quote site jesowner=jobownername
200 SITE command was accepted
ftp> get  JOBxxxxx.6  c:\data\csvreport.csv
200 Port request OK.
125 Sending data set USERNAME.XML#A11.JOBxxxxx.D1111111.?
250 Transfer completed successfully.
ftp: 1111 bytes received in 0,11Seconds 11,11Kbytes/sec.
ftp> bye
221 Quit command received. Goodbye.

Explanation of commands used in the example:

ftp

Invokes the ftp client.

open server.organization.com

Connects to specified server. Replace server.organization.com with the network address of the server you are connecting to.

username, userpassword

Specifies the user name and password. Replace username and userpassword with valid user credentials.

quote site filetype=jes

Creates the connection to JES spool files.

quote site jesjobname=*

Uses all available jobs.

quote site jobowner=jobownername

Selects only the job of the specified user. Replace jobownername with the valid user ID of the job owner.

get JOBxxxxx.6 c:\data\csvreport.csv

Indicates the client is ready to download the report.

JOBxxxxx.6

The client finds the report by job ID and extension. Job ID is formatted as JOBxxxxx where xxxxx is the job number. The extension (in this example, the number six after the period) tells the client which spool file to download. Spool files belonging to the specified job are numbered starting with one. So in this example the CSV report would be the sixth spool file belonging to the specified job.

c:\data\csvreport.csv

Provides the fully qualified path where you want to store the report on your computer.

bye

Closes the ftp client.