Downloading records in Fileaid



Compuware's data management products: File-AID for IMS, File-AID/MVS, File-AID for DB2 and DBA-XPERT for DB2

Downloading records in Fileaid

Postby wxs3 » Tue Apr 05, 2011 6:03 am

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.
wxs3
 
Posts: 4
Joined: Tue Apr 05, 2011 5:58 am
Has thanked: 0 time
Been thanked: 0 time

Re: Downloading records in Fileaid

Postby wxs3 » Tue Apr 05, 2011 6:37 am

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.
wxs3
 
Posts: 4
Joined: Tue Apr 05, 2011 5:58 am
Has thanked: 0 time
Been thanked: 0 time

Re: Downloading records in Fileaid

Postby Robert Sample » Tue Apr 05, 2011 6:41 am

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.
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Downloading records in Fileaid

Postby wxs3 » Tue Apr 05, 2011 7:14 am

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?
wxs3
 
Posts: 4
Joined: Tue Apr 05, 2011 5:58 am
Has thanked: 0 time
Been thanked: 0 time

Re: Downloading records in Fileaid

Postby Robert Sample » Tue Apr 05, 2011 3:44 pm

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.
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Downloading records in Fileaid

Postby wxs3 » Wed Apr 06, 2011 7:39 am

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
wxs3
 
Posts: 4
Joined: Tue Apr 05, 2011 5:58 am
Has thanked: 0 time
Been thanked: 0 time

Re: Downloading records in Fileaid

Postby BillyBoyo » Wed Apr 06, 2011 12:01 pm

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to File-AID

 


  • Related topics
    Replies
    Views
    Last post