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

Need to process a spreadsheet in rexx


IBM Mainframe Forums -> CLIST & REXX
Post new topic   Reply to topic
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
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

Superior Member


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

PostPosted: Tue Jan 20, 2009 3:21 pm
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: 8797
Location: Welsh Wales

PostPosted: Tue Jan 20, 2009 3:23 pm
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
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

Moderator Emeritus


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

PostPosted: Wed Jan 21, 2009 3:45 am
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: 400
Location: Mumbai

PostPosted: Wed Jan 21, 2009 4:16 am
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
Reply with quote

Hi Mbabu,
Thanks the information you provided was useful and also i found this link which elaborate more on this topic.
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CLIST & REXX

 


Similar Topics
Topic Forum Replies
No new posts Compile Several JCL JOB Through one r... CLIST & REXX 4
No new posts Running REXX through JOB CLIST & REXX 13
No new posts Error to read log with rexx CLIST & REXX 11
No new posts isfline didnt work in rexx at z/OS ve... CLIST & REXX 7
No new posts run rexx code with jcl CLIST & REXX 15
Search our Forums:

Back to Top