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
 

 

Need to process a spreadsheet in rexx

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
View previous topic :: :: View next topic  
Author Message
usharaniA

New User


Joined: 22 Jan 2008
Posts: 85
Location: India

PostPosted: Tue Jan 20, 2009 2:18 pm    Post subject: Need to process a spreadsheet in rexx
Reply with quote

Hi,
I want to know is there any option of opening the windows command prompt from the tso regions or through rexx code.

My requirement is to open a excel sheet from a rexx code.
So i thought of invoking the excel sheet from the windows command prompt and the command prompt from the mainframe.
If my question is not reasonable please forgive me.
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Jan 20, 2009 3:21 pm    Post subject:
Reply with quote

Hi,

This is a way you thought to meet your requirement, 'am sure it's not the actual requirement. If you tell us what you are looking for some one will be around with a better suggestion.

Quote:
My requirement is to open a excel sheet from a rexx code.
Sure ? Any how if we could do it then what's next?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Jan 20, 2009 3:23 pm    Post subject:
Reply with quote

You would probably export to a csv or txt file and upload to the mainframe and process it that way.
Back to top
View user's profile Send private message
usharaniA

New User


Joined: 22 Jan 2008
Posts: 85
Location: India

PostPosted: Tue Jan 20, 2009 3:27 pm    Post subject:
Reply with quote

ya this is way i plan to do.
I dont understand you expat. can you pleaase elaborate .
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jan 21, 2009 3:45 am    Post subject:
Reply with quote

Hello,

On the pc, save the spreadsheet into a delimited test file and upload that file to the mainframe for processing n rexx.
Back to top
View user's profile Send private message
MBabu

Active User


Joined: 03 Aug 2008
Posts: 401
Location: Mumbai

PostPosted: Wed Jan 21, 2009 4:16 am    Post subject: Reply to: Need to process a spreadsheet in rexx
Reply with quote

ISPF workstation client or whatever it is called will do this for you. See FILEXFER and SELECT WSCMD()
Back to top
View user's profile Send private message
usharaniA

New User


Joined: 22 Jan 2008
Posts: 85
Location: India

PostPosted: Wed Jan 21, 2009 10:26 am    Post subject:
Reply with quote

Hi Mbabu,
Thanks the information you provided was useful and also i found this link which elaborate more on this topic.
http://www.sillysot.com/mvs/index.htm?ispfhtml.htm
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 -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts REXX DB2: Dynamic allocation of DB2.D... BHAS CLIST & REXX 3 Mon Dec 19, 2016 8:26 pm
No new posts find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm


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