IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

FTP to transfer files from Mainframe


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
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
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: 8796
Location: Welsh Wales

PostPosted: Tue Jul 30, 2013 4:39 pm
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: 8700
Location: Dubuque, Iowa, USA

PostPosted: Tue Jul 30, 2013 4:51 pm
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

Moderator Emeritus


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

PostPosted: Tue Jul 30, 2013 8:56 pm
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: 765
Location: Whitby, ON, Canada

PostPosted: Wed Jul 31, 2013 3:01 am
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

Moderator Emeritus


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

PostPosted: Wed Jul 31, 2013 3:20 am
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
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

Senior Member


Joined: 07 Feb 2009
Posts: 1315
Location: Vilnius, Lithuania

PostPosted: Wed Jul 31, 2013 4:28 pm
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: 8796
Location: Welsh Wales

PostPosted: Wed Jul 31, 2013 4:29 pm
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: 1787
Location: Bloomington, IL

PostPosted: Wed Jul 31, 2013 4:31 pm
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
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: 2454
Location: Hampshire, UK

PostPosted: Wed Jul 31, 2013 6:40 pm
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

Superior Member


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

PostPosted: Wed Jul 31, 2013 7:11 pm
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

Moderator Emeritus


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

PostPosted: Wed Jul 31, 2013 7:24 pm
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
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

Moderator Emeritus


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

PostPosted: Wed Jul 31, 2013 11:39 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts 3 files concatenated to 1 DFSORT/ICETOOL 2
No new posts JCL sort to compare dates in two file... DFSORT/ICETOOL 2
No new posts Email attachment from mainframe is empty PC Guides & IT News 9
No new posts Mainframe Dataset Binary or ASCII Mainframe Interview Questions 4
No new posts Need help In Mainframe Automation AF/... CLIST & REXX 14
Search our Forums:

Back to Top