Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
FTP excel file to mainframe dataset

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
kunal jain

New User


Joined: 19 May 2011
Posts: 59
Location: India

PostPosted: Sun Apr 12, 2015 2:25 am    Post subject: FTP excel file to mainframe dataset
Reply with quote

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
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Sun Apr 12, 2015 3:06 am    Post subject: Reply to: FTP excel file to mainframe dataset
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8187
Location: East Dubuque, Illinois, USA

PostPosted: Sun Apr 12, 2015 3:16 am    Post subject:
Reply with quote

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
View user's profile Send private message
kunal jain

New User


Joined: 19 May 2011
Posts: 59
Location: India

PostPosted: Sun Apr 12, 2015 5:49 am    Post subject:
Reply with quote

Thank Robert for your response.

Can you please tell me how do i convert excel spreadsheet(.xls) into .csv format.

Thanks
Back to top
View user's profile Send private message
steve-myers

Active Member


Joined: 30 Nov 2013
Posts: 585
Location: The Universe

PostPosted: Sun Apr 12, 2015 10:37 am    Post subject:
Reply with quote

The Excel program will do it.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8187
Location: East Dubuque, Illinois, USA

PostPosted: Sun Apr 12, 2015 5:51 pm    Post subject:
Reply with quote

In Excel, File -> Save As and select the appropriate format.
Back to top
View user's profile Send private message
Radhika Nambiar

New User


Joined: 30 Mar 2016
Posts: 7
Location: INDIA

PostPosted: Wed Mar 30, 2016 5:20 pm    Post subject:
Reply with quote

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
View user's profile Send private message
prino

Senior Member


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

PostPosted: Wed Mar 30, 2016 5:39 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8187
Location: East Dubuque, Illinois, USA

PostPosted: Wed Mar 30, 2016 6:09 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Akatsukami

Global Moderator


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

PostPosted: Wed Mar 30, 2016 6:25 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8187
Location: East Dubuque, Illinois, USA

PostPosted: Wed Mar 30, 2016 6:36 pm    Post subject:
Reply with quote

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! icon_biggrin.gif
Back to top
View user's profile Send private message
Radhika Nambiar

New User


Joined: 30 Mar 2016
Posts: 7
Location: INDIA

PostPosted: Wed Mar 30, 2016 7:02 pm    Post subject:
Reply with quote

Sorry about the unprofessional language used by me.

Thank you all for your time.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1922
Location: UK

PostPosted: Wed Mar 30, 2016 10:03 pm    Post subject:
Reply with quote

locking as the question is in the beginner's forum.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    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 Mainframe Blocks to Tracks conversion upendrasri JCL & VSAM 1 Sat Nov 18, 2017 10:52 am
No new posts VBS and VB, COBOL syntax is the same ... natt.sut COBOL Programming 3 Sun Nov 12, 2017 6:36 am
No new posts Updating data from one file to other!!! Vignesh Sid SYNCSORT 1 Mon Nov 06, 2017 2:42 pm
This topic is locked: you cannot edit posts or make replies. Need help how to pass the ESP variabl... Venkichaitu JCL & VSAM 12 Thu Nov 02, 2017 3:53 am
This topic is locked: you cannot edit posts or make replies. Comparing current time with the time ... arunsoods SYNCSORT 1 Mon Oct 30, 2017 4:07 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us