Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to read a excel sheet and load it into mainframes

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries
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    Post subject: How to read a excel sheet and load it into mainframes
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: 7914
Location: Bellevue, IA

PostPosted: Wed Mar 30, 2016 4:58 pm    Post subject:
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    Post subject:
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    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?

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: 7914
Location: Bellevue, IA

PostPosted: Wed Mar 30, 2016 6:15 pm    Post subject:
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    Post subject:
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: 1238
Location: Richfield, MN, USA

PostPosted: Wed Mar 30, 2016 7:44 pm    Post subject:
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: 1445
Location: Azeroth

PostPosted: Wed Mar 30, 2016 9:33 pm    Post subject:
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: 1717
Location: UK

PostPosted: Wed Mar 30, 2016 9:58 pm    Post subject:
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    Post subject:
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    Post subject: Reply to: How to read a excel sheet and load it into mainframes
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    IBMMAINFRAMES.com Support Forums -> Java & MQSeries All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts CICS VSAM RLS READ akodakka CICS 3 Tue Oct 04, 2016 3:09 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Copybook structure in Load module Vai123 COBOL Programming 7 Fri Sep 16, 2016 8:29 pm
This topic is locked: you cannot edit posts or make replies. ERROR WHILE SUBMITTING LOAD JOB ANURADHA NEELAKANTAN JCL & VSAM 12 Thu Aug 25, 2016 11:50 am
No new posts Multi row fetch - "for read only... Nileshkul DB2 3 Sun Aug 14, 2016 12:52 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us