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

How to read a excel sheet and load it into mainframes


IBM Mainframe Forums -> Java & MQSeries
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Radhika Nambiar

New User


Joined: 30 Mar 2016
Posts: 7
Location: INDIA

PostPosted: Wed Mar 30, 2016 4:49 pm
Reply with quote

Hi All. Am new to natural. Can anyone guide me how to read a excel sheet and load it into the mainframe system. I went through the posts and found out we can convert it into CSV format and proceed. But how do we write a JCL for the same. Also is it possible to use GET/PUT for the same purpose?
icon_smile.gif
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Wed Mar 30, 2016 4:58 pm
Reply with quote

Usually, you cannot write a JCL for this -- JCL executes FTP, which requires the other side of the connection to be a server, and few (if any) desktop systems are servers. If the spreadsheet has more than one tab, each has to be individually converted to a .CSV and transferred to the mainframe, unless your site has one of the products that allow you to manipulate Excel on a mainframe directly.
Quote:
Also is it possible to use GET/PUT for the same purpose?
If you are talking about FTP, then yes you FTP the .CSV file to a mainframe data set by using PUT in FTP.
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:04 pm
Reply with quote

Thank you Robert for the quick reply. Am not fully clear but now have an idea to start working.

Cheers!!
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:19 pm
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?

Robert Sample wrote:
Usually, you cannot write a JCL for this -- JCL executes FTP, which requires the other side of the connection to be a server, and few (if any) desktop systems are servers. If the spreadsheet has more than one tab, each has to be individually converted to a .CSV and transferred to the mainframe, unless your site has one of the products that allow you to manipulate Excel on a mainframe directly.
Quote:
Also is it possible to use GET/PUT for the same purpose?
If you are talking about FTP, then yes you FTP the .CSV file to a mainframe data set by using PUT in FTP.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Wed Mar 30, 2016 6:15 pm
Reply with quote

You don't need to post the same question is multiple places. This will not get you faster or better answers, it just annoys people.

You should start your own topic in the appropriate place in the forum when you have a question, not add to the end of an existing topic.
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:06 pm
Reply with quote

I was not trying to post the same question at multiple places to get quick responses or better answers. Not yet accustomed to the forum's working.A newcomer's honest mistake.

Again. Thank you for your time.
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Wed Mar 30, 2016 7:44 pm
Reply with quote

At the Home Page, there's an area called Site Announcements, Forum Rules which newcomers should read and adhere to.
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Wed Mar 30, 2016 9:33 pm
Reply with quote

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?


This can be done via several methods.
1. From your Windows command prompt - You can perform an FTP from PC to mainframe. Provided your shop allows it.

2. Another easier method is by using your Mainframe emulator. Emulator is the software you use to view mainframe screens. As far as I know most emulators have an option to transfer files to HOST(mainframe)
It most likely would be GUI based and easy.

You cannot do this with JCL. Unless your PC runs a FTP server, which is unlikely.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Wed Mar 30, 2016 9:58 pm
Reply with quote

Just remember that JCL itself will not do it as all that JCL does is tell the mainframe what programs you want to run and the resources required by those programs. It is the program that does the work - ftp or whatever.
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 10:05 pm
Reply with quote

Thank You all for clearing my doubt. icon_biggrin.gif
Back to top
View user's profile Send private message
Ralph Zbrog

New User


Joined: 21 Nov 2009
Posts: 58
Location: California

PostPosted: Fri Apr 01, 2016 1:27 am
Reply with quote

Natural running on Unix/Linux or Windows can handle CSVs natively, but not on the mainframe. It would be a bit of a challenge even for an experienced Natural programmer to parse a CSV.

Rather than a CSV, create a Formatted Text (Space Delimited) file. This will contain the fixed format fields which are expected by mainframe Natural.
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 -> Java & MQSeries

 


Similar Topics
Topic Forum Replies
No new posts SH256/MD5 Checksum in Mainframes JCL JCL & VSAM 14
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Load new table with Old unload - DB2 DB2 6
No new posts How to load to DB2 with column level ... DB2 6
No new posts REASON 00D70014 in load utility DB2 6
Search our Forums:

Back to Top