|
View previous topic :: View next topic
|
| Author |
Message |
Radhika Nambiar
New User
Joined: 30 Mar 2016
Posts: 7
Location: INDIA
|
|
|
|
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?
 |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
Radhika Nambiar
New User
Joined: 30 Mar 2016
Posts: 7
Location: INDIA
|
|
|
|
Thank you Robert for the quick reply. Am not fully clear but now have an idea to start working.
Cheers!! |
|
| 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?
| 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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
Radhika Nambiar
New User
Joined: 30 Mar 2016
Posts: 7
Location: INDIA
|
|
|
|
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 |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008
Posts: 1248
Location: Richfield, MN, USA
|
|
|
|
| At the Home Page, there's an area called Site Announcements, Forum Rules which newcomers should read and adhere to. |
|
| Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007
Posts: 1744
Location: Tirupur, India
|
|
|
|
| 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 |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
| 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 |
|
|
Radhika Nambiar
New User
Joined: 30 Mar 2016
Posts: 7
Location: INDIA
|
|
|
|
Thank You all for clearing my doubt.  |
|
| Back to top |
|
|
Ralph Zbrog
New User
Joined: 21 Nov 2009
Posts: 58
Location: California
|
|
|
|
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 |
|
|
|
|
