Code in excel macro for mainframe blue zone emulator

gyan2march · New User Joined: 15 Nov 2011 Posts: 7 Location: India

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.

PeterHolland · Posted: Thu Jan 26, 2012 12:57 pm

Why not use the macro facility most terminal emulators have?

gyan2march · New User Joined: 15 Nov 2011 Posts: 7 Location: India

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.

PeterHolland · Posted: Thu Jan 26, 2012 1:18 pm

And that is possible too.

gyan2march · New User Joined: 15 Nov 2011 Posts: 7 Location: India

I use blue zone emulator .... not sure how possible its through that

PeterHolland · Posted: Thu Jan 26, 2012 1:30 pm

Try the manual(s).

I did it once with Host On demand. Blue zone uses vbscript so i guess it should be possible.

gyan2march · New User Joined: 15 Nov 2011 Posts: 7 Location: India

Hi,

Sorry to post after a long time. I am looking for possible answers if any. Plz help.

dick scherrer · Posted: Wed May 23, 2012 12:44 am

Hello,

Suggest you ask Blue Zone support. They should be able to explain how this might be done with their product.

dbzTHEdinosauer · Posted: Wed May 23, 2012 1:37 am

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.