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
 

 

Code in excel macro for mainframe blue zone emulator

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
gyan2march

New User


Joined: 15 Nov 2011
Posts: 7
Location: India

PostPosted: Thu Jan 26, 2012 12:52 pm    Post subject: Code in excel macro for mainframe blue zone emulator
Reply with quote

Hi All,

I want to make a repetitive job easier by making a macro. My requirement is:

I will place some input on excel sheet and I want to design a macro such that it takes the input from sheet and does some operations in mainframe. I am confused on how to link my sheet to mainframe screen. Please guide.

Also, please let me know if its not the right place to discuss as I didn't find a suitable place.

Any help will be appreciated.
Back to top
View user's profile Send private message

PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Thu Jan 26, 2012 12:57 pm    Post subject:
Reply with quote

Why not use the macro facility most terminal emulators have?
Back to top
View user's profile Send private message
gyan2march

New User


Joined: 15 Nov 2011
Posts: 7
Location: India

PostPosted: Thu Jan 26, 2012 1:13 pm    Post subject:
Reply with quote

Thats because every time input will be different. I want to put input in excel sheet and pick from there and then run the mainframe according to input.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Thu Jan 26, 2012 1:18 pm    Post subject:
Reply with quote

And that is possible too.
Back to top
View user's profile Send private message
gyan2march

New User


Joined: 15 Nov 2011
Posts: 7
Location: India

PostPosted: Thu Jan 26, 2012 1:21 pm    Post subject:
Reply with quote

I use blue zone emulator .... not sure how possible its through that icon_sad.gif
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Thu Jan 26, 2012 1:30 pm    Post subject:
Reply with quote

Try the manual(s).

I did it once with Host On demand. Blue zone uses vbscript so i guess it should be possible.
Back to top
View user's profile Send private message
gyan2march

New User


Joined: 15 Nov 2011
Posts: 7
Location: India

PostPosted: Wed May 23, 2012 12:10 am    Post subject: Reply to: Code in excel macro for mainframe blue zone emulat
Reply with quote

Hi,

Sorry to post after a long time. I am looking for possible answers if any. Plz help.
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 May 23, 2012 12:44 am    Post subject:
Reply with quote

Hello,

Suggest you ask Blue Zone support. They should be able to explain how this might be done with their product.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed May 23, 2012 1:37 am    Post subject:
Reply with quote

gyan2march.

i dooo believe that you have it ass-backwards.

when you are ready to close the excel sheet,
have an excel macro save the sheet in proper format,
and execute a PC Script (or bat file)
that will instigate the upload process and whatever job to be performed on the Mainframe.

probably be easiest to just have a job on the mainframe submitted,
that will:
1. upload (ndm, ftp, whatever) the sheet in text format to the mainframe
2. do your processing.

why would you want to have to go to the emulator to do this?

emulator is nothing but a communications method between your pc and the mainframe.
the emulator is but one task on you pc,
and should be used for doing things on the mainframe.

if you are doing something on the pc
and then want something to happen on the mainframe that is dependent on you last pc work,
then use that to initiate the mainframe side.

it may be that you have to first copy your file to one of your servers,
that is already 'coupled with the mainframe' thru NDM or something.

if this process is going to be promoted to production,
i imagine (if your site has any acceptable IT standards)
there exists on the server somekind of template you can use to make your own unique process.

i have seen idiots design this kind of garbage before
(weeks spent writing an emulator macro
that uploads something thru the emulator)
which means they sit there with their thumb up their ass
because their session is tied up transferring some fucking file
the transfer for which was initiated with limited keystrokes.

if you are going to automate something,
automate it so that it does not interfere with you mainframe session.
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 -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 1 Mon Dec 05, 2016 11:57 am
No new posts What is the code in CLIST to enable t... jackzhang75 CLIST & REXX 1 Fri Dec 02, 2016 3:02 am
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm
No new posts IDEAL - Code Retrieval yugendran CA Products 0 Fri Nov 25, 2016 3:27 pm
This topic is locked: you cannot edit posts or make replies. Mainframe Developer requirement in Ku... capricorn Mainframe Jobs 0 Sun Oct 23, 2016 3:49 pm


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