View previous topic :: View next topic
|
Author |
Message |
Mainforum
New User
Joined: 30 May 2013 Posts: 8 Location: India
|
|
|
|
I want to know how to transfer files from mainframe using 3.6 option?
Can anyone help me out? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8700 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
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 |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Or just 6 . . .
For the command shell . . . ?
maybe we'll get some clarification?
d |
|
Back to top |
|
|
Mainforum
New User
Joined: 30 May 2013 Posts: 8 Location: India
|
|
|
|
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 |
|
|
prino
Senior Member
Joined: 07 Feb 2009 Posts: 1315 Location: Vilnius, Lithuania
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8796 Location: Welsh Wales
|
|
|
|
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 |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1787 Location: Bloomington, IL
|
|
|
|
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 |
|
|
Gary McDowell
Active User
Joined: 15 Oct 2012 Posts: 139 Location: USA
|
|
|
|
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 |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2454 Location: Hampshire, UK
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Gary McDowell
Active User
Joined: 15 Oct 2012 Posts: 139 Location: USA
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
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 |
|
|
|