IBM Mainframe Forum

Hi
This is a bit of a dumb question, but I can't find it on any forums.
After I've selected records in Fileaid, I'd like to dowloand them to my C drive in CSV or Excel etc.
How do I download this? I've managed to work out that I have to print it, but what do I put in the JCL for it to just download?

Any help would be appreciated.

OK - I've managed to get a print output - all I need to know now is how to download the print output to text/excel.

1. Route the print to an output data set.
2. Use FTP on the PC side to download the output data set to your PC.

Note that in general you cannot submit a job on the mainframe to transfer a file to your PC. FTP connections go from the client to the server, and unless your PC is doing the extremely rare feat of running server software, it is not possible for the mainframe to connect to it.

When you say FTP on the PC side, how do I do that? And what file name should I be looking for for the print output?

Get a command prompt and enter ftp, or use Run and enter ftp, or use WS-FTP, or ... Which method you use depends upon what your site standard is and what is installed on your machine.

OK - so I've figured out how to FTP/Download, but how what's wrong with my print job? I'm using this in the JCL and it just doesn't want to create anything in the spool. What's wrong? Your help is appreciated.

000013 //JS10 EXEC PGM=FILEAID,REGION=6M
000014 //STEPLIB DD DISP=SHR,DSN=SYS3.FILEAID.LOADLIB
000015 //SYSPRINT DD SYSOUT=*
000016 //SYSLIST DD SYSOUT=*
000017 //DD01 DD DSN=xxx.COC.WORK1006.PCMF180T.OUTPUT,
000018 // DISP=SHR
000019 //DD01RL DD DSN=xxx.COC.TARGET,
000020 // DISP=SHR
000021 //DD01SC DD DSN=xxx.FILEAID.SC.D11096.T140413(SELECT),
000022 // DISP=(OLD,DELETE,DELETE)
000023 //SYSIN DD *
000024 $$DD01 RLPRINT SHOW=PICTURE,LAYOUT=PCMFD80O

The job can't do nothing. When you submit it, there must be some output. Look at the log messages, sysprint and syslist. Must tell you something. If you don't understand what it says, post it here.