Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

FTP to transfer files from mainframe

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
Mainforum

New User


Joined: 30 May 2013
Posts: 8
Location: India

PostPosted: Tue Jul 30, 2013 4:18 pm    Post subject: FTP to transfer files from mainframe
Reply with quote

I want to know how to transfer files from mainframe using 3.6 option?
Can anyone help me out?
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Jul 30, 2013 4:39 pm    Post subject:
Reply with quote

What's 3.6 option - mine is set up to perform hardcopy printing here.

Perhaps if you can be bothered to explain EXACTLY what it is that you want to do, in detail, then maybe people may be able to help you.

With the information that you have given so far, you will be very lucky indeed if anyone can
a) Bother to help you
b) Help you if they wanted to
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7904
Location: Bellevue, IA

PostPosted: Tue Jul 30, 2013 4:51 pm    Post subject:
Reply with quote

What is 3.6 option for you? I assume you're talking about ISPF option 3.6 which on my system (and most systems I've used) is the Hardcopy Utility used EXCLUSIVELY for printing.

There are a number of ways to transfer files from a mainframe, depending upon the destination computer and the resources available to your site. Possible methods include:
1. FTP (batch JCL or ISPF option 6 -- ISPF Command Shell)
2. NDM (third party software not installed at all sites)
3. SMTP attachment
etc.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jul 30, 2013 8:56 pm    Post subject:
Reply with quote

Hello,

Suggest you create some batch JCL to do this.

Once you have one working, you can easily clone it for other file transfers.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Wed Jul 31, 2013 3:01 am    Post subject:
Reply with quote

Well, there is 3.7 (not 3.6) which uses Workstation Agent to transfer files. That's probably not what the TS is looking for though.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jul 31, 2013 3:20 am    Post subject:
Reply with quote

Or just 6 . . .

For the command shell . . . ?

maybe we'll get some clarification?

d
Back to top
View user's profile Send private message
Mainforum

New User


Joined: 30 May 2013
Posts: 8
Location: India

PostPosted: Wed Jul 31, 2013 4:12 pm    Post subject:
Reply with quote

My apologize.

I am talking about ISPF option 6 (Command). Using this option,we can transfer the files from Mainframe to txt file. Likewise how to transfer the mainframe to .xls. I tried but in ecxel I could see only the junk values. Can anyone help me?
Back to top
View user's profile Send private message
prino

Active Member


Joined: 07 Feb 2009
Posts: 982
Location: Oostende, Belgium

PostPosted: Wed Jul 31, 2013 4:28 pm    Post subject:
Reply with quote

Mainforum wrote:
I am talking about ISPF option 6 (Command). Using this option,we can transfer the files from Mainframe to txt file. Likewise how to transfer the mainframe to .xls. I tried but in ecxel I could see only the junk values. Can anyone help me?


"the junk values"? Such as?

How are you creating the .xls files on z/OS? Does your organization have software to do so, as the XLS format is proprietary and is still not completely reverse engineered.

How are you transferring them to the non-mainframe box, binary or ASCII?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Jul 31, 2013 4:29 pm    Post subject:
Reply with quote

One assumes that you have transferred a CSV file from the mainframe to the PC. One can only assume because you still don't really want to tell us anything, and unless you do tell us things the willingness to help you will dry out very fast.

Have you tried by transferring the assumed CSV file to the PC and then using excel to import that file ?
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Wed Jul 31, 2013 4:31 pm    Post subject:
Reply with quote

Mainforum wrote:
My apologize.

I am talking about ISPF option 6 (Command). Using this option,we can transfer the files from Mainframe to txt file. Likewise how to transfer the mainframe to .xls. I tried but in ecxel I could see only the junk values. Can anyone help me?

You can't transfer data from a MVS system to an actual .xls file without some proprietary (and expensive) software; you must transfer a CSV or as HTML. When you do (and vanilla FTP won't do that formatting), you must enable EBCDIC/ASCII translation to avoid "junk" values ("junk" only to toy computers and toy programmers, which can't deal with any but character data).
Back to top
View user's profile Send private message
Gary McDowell

Active User


Joined: 15 Oct 2012
Posts: 139
Location: USA

PostPosted: Wed Jul 31, 2013 6:17 pm    Post subject:
Reply with quote

From my notes which may help. You may have a different product on your mainframe but they all work in a similar fashion. Good luck!

-> Transfer file in TSO:

-- Mainframe to PC
--- Go into TSO ISPF Command Shell (=6).
--- Click on Transfer Files under Actions, Transfer Files, Receive Files from Host
--- Enter Host-File Name with single quotes (Mainframe file)
'TEST.xxx'
--- Enter Local-File Name (PC File) [use Browse]
\\...xxx.txt
--- Transfer Mode...Text
--- Options; ASCII CRLF
--- Click on Add to List
--- Click on Receive
The mainframe file should be in a '.txt' file on your PC.

-- PC to Mainframe
--- Go into TSO ISPF Command Shell (=6).
--- Click on Transfer Files under Actions, Transfer Files, Send Files to Host
--- Enter Local-File Name (PC File) [use Browse]
\\...xxx.txt
--- Enter Host-File Name with single quotes (Mainframe file)
'TEST.xxx'
--- Transfer Mode...Text
--- Options; ASCII CRLF RECFM(F) LRECL(80)
--- Click on Add to List
--- Click on Send
The PC file should now be in a mainframe file.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1712
Location: UK

PostPosted: Wed Jul 31, 2013 6:40 pm    Post subject:
Reply with quote

I do not have Actions in option 6 - perhaps you mean switch to your emulator after going to to option 6 (which is 5 in our place - ye gods!) and then click on Actions there (which is Transfer on my emulator)
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Jul 31, 2013 7:11 pm    Post subject:
Reply with quote

Yeah, I too, think that Gary meant "switch to your emulator after going to to option 6". On the other hand, these options vary emulator to emulator. For example, on BlueZone similar options are available using Transfer/Configure. Also, with PCOM, what I recall from a distant memory that, "Mainframe was reference" while on BlueZone "PC is reference". So the notion "PC to Mainframe" and "Mainframe to PC" might also vary based on the emulator you are using while you choose (click) on send/receive "button".
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jul 31, 2013 7:24 pm    Post subject:
Reply with quote

Hello,

Quote:
Using this option,we can transfer the files from Mainframe to txt file
Yes, you can transfer a text file . . .

However, you need to make sure you have properly formatted the text file for use on the Win-box.

One of the easiest ways to do this is to create a data-delimited (we use the tab character (x'05') as this will not occur in your regular text) file and import this into the Win-app after transfer.
Back to top
View user's profile Send private message
Gary McDowell

Active User


Joined: 15 Oct 2012
Posts: 139
Location: USA

PostPosted: Wed Jul 31, 2013 11:04 pm    Post subject:
Reply with quote

Nic Clouston wrote:
I do not have Actions in option 6 - perhaps you mean switch to your emulator after going to to option 6 (which is 5 in our place - ye gods!) and then click on Actions there (which is Transfer on my emulator)

Yes, emulator. I couldn't think of the term at the time.

My current emulator has - Actions > Transver Files > etc.
I have seen emulators that have - Tools > etc.

They all work in a similar fashion no matter what emulator you are using.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jul 31, 2013 11:39 pm    Post subject:
Reply with quote

Hello,

If you are going to use the PC to 'pull' the data from the mainframe, one easy way is to use the FTP client on the PC. Every tcp/ip product i've seen comes with an FTP client and this is independent of the terminal emulator being used.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 8 Thu Dec 01, 2016 8:28 pm
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
This topic is locked: you cannot edit posts or make replies. Mainframe Developer requirement in Ku... capricorn Mainframe Jobs 0 Sun Oct 23, 2016 3:49 pm
This topic is locked: you cannot edit posts or make replies. How to use 2 input files in control c... Gunapala CN DFSORT/ICETOOL 23 Thu Oct 13, 2016 3:42 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us