|
View previous topic :: View next topic
|
| Author |
Message |
kunal jain
New User
Joined: 19 May 2011
Posts: 59
Location: India
|
|
|
|
Hi
I need to import excel file to ZOS mainframe. When I FTP excel file to mainframe dataset using 3.6 option, data in mainframe dataset is coming as junk-value or not readable.
Is there a way to import Excel file to mainframe dataset properly. Thanks for your help in advance ! |
|
| Back to top |
|
 |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
Depends what you mean by an Excel file. If you mean a "CSV" or "TXT" file, then yes, just make sure you tell it to do ASCII to EBCDIC conversion.
If you mean a speadsheet itself, it depends what you want to do with it. |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
If you want to transfer an Excel file to the mainframe, there are several things to consider:
1. If the spreadsheet has a single tab, using .TXT or .CSV format will transfer the data.
2. If the spreadsheet has multiple tabs, convert each to a .TXT or .CSV format and transfer them separately.
3. If you want to transfer the Excel file directly and use it, you could convince your company to spend the $100,000 (or more) required to buy one of the software products that can handle Excel files on the mainframe. If your site already has such a product, then use it.
4. Or you could get a copy of the Excel file specification (well over 1,000 pages the last time I looked), and use that to write a mainframe program to directly read and process the data yourself -- this probably won't take more than a year or so (with enough people on the project). |
|
| Back to top |
|
|
kunal jain
New User
Joined: 19 May 2011
Posts: 59
Location: India
|
|
|
|
Thank Robert for your response.
Can you please tell me how do i convert excel spreadsheet(.xls) into .csv format.
Thanks |
|
| Back to top |
|
|
steve-myers
Active Member
Joined: 30 Nov 2013
Posts: 917
Location: The Universe
|
|
|
|
| The Excel program will do it. |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| In Excel, File -> Save As and select the appropriate format. |
|
| Back to top |
|
|
Radhika Nambiar
New User
Joined: 30 Mar 2016
Posts: 7
Location: INDIA
|
|
|
|
| Hi All. I have a excel in CSV format. Now I need to load it into a dataset so that it can be read from a program. This can be done by a JCL rite? |
|
| Back to top |
|
|
prino
Senior Member
Joined: 07 Feb 2009
Posts: 1306
Location: Vilnius, Lithuania
|
|
|
|
Don't attach new postings to old threads!
What is a "JCL rite".
Most of us probably know about "last rites", but I'm sure all of us are curious about "JCL rites". |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| Quote: |
| This can be done by a JCL rite? |
First, this a forum for professional programmers -- if you meant "right" by "rite", then you saved one letter typing and caused a lot of questions to people reading your post. As a professional, you are expected to use proper English in your posts and using "rite" for "right" is not proper English. If you actually meant "rite", you'll have to explain that to us since it makes no sense to me.
Second, if the .CSV file is on a server then yes you can use a JCL to FTP the .CSV file to a mainframe data set. Will the JCL work? Well, that depends upon a number of factors -- such as whether or not the server has FTP listening, if your mainframe user id has access to the directory and file, and so forth.
If the .CSV file is on your PC (laptop or desktop doesn't matter) you have two choices: move it to a server you can use JCL to FTP from, or use FTP on your PC to FTP the file to the mainframe. Note that in this case there will not, under ANY circumstances, be JCL involved so the answer to your question would be no, this cannot be done by JCL. |
|
| Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
|
|
|
|
| Robert Sample wrote: |
| First, this a forum for professional programmers -- if you meant "right" by "rite", then you saved one letter typing and caused a lot of questions to people reading your post. As a professional, you are expected to use proper English in your posts and using "rite" for "right" is not proper English. If you actually meant "rite", you'll have to explain that to us since it makes no sense to me. |
A JCL rite probably involves robes, chanting, incense, and sacrificing chickens, like setting up a SCSI chain. |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| Quote: |
| A JCL rite probably involves robes, chanting, incense, and sacrificing chickens, like setting up a SCSI chain. |
Not again! I just got the chicken blood off the box from the LAST time!  |
|
| Back to top |
|
|
Radhika Nambiar
New User
Joined: 30 Mar 2016
Posts: 7
Location: INDIA
|
|
|
|
Sorry about the unprofessional language used by me.
Thank you all for your time. |
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK
|
|
|
|
| locking as the question is in the beginner's forum. |
|
| Back to top |
|
|
|
|
