Get the data from mainframes automatically.

Other Mainframe related questions which attracts you and there is no suitable Forum you find for it and related FAQs.

Topic author
Neeraj N
Registered Member
Posts: 34
Joined: Tue Aug 20, 2013 12:49 pm
Has thanked: 2 times

Get the data from mainframes automatically.

Postby Neeraj N » Mon Jun 05, 2017 11:00 pm


From the performance team we came to know that most of the programmers at our site spends nearly 80%-85% of their time requesting data from a COBOL mainframe. And they just do it to lager use it into excel for some kind of reporting. As the reports are needed daily, they run the same queries each day. Trying to figure out of this be automated in any way?

Thanks for any help.

User avatar

Global Moderator
Global Moderator
Posts: 105
Joined: Tue Oct 20, 2015 3:20 am
Location: Bloomington, IL
Has thanked: 2 times
Been thanked: 14 times

Re: Get the data from mainframes automatically.

Postby Akatsukami » Mon Jun 05, 2017 11:41 pm

Yes, this can trivially be done. However, I would question if 80-85% of their time is really spent doing this (if so, it speaks very poorly for their competence) and if they really run the same queries each time (again, if so, it speaks very poorly for their competence).

"I come to the conclusion that, men loving according to their own will and fearing according to that of the prince, a wise prince should establish himself on that which is in his own control and not in that of others." -- Niccolò Machiavelli

User avatar

Robert Sample
Global Moderator
Global Moderator
Posts: 1275
Joined: Fri Jun 28, 2013 1:22 am
Location: East Dubuque Illinois
Has thanked: 2 times
Been thanked: 90 times

Re: Get the data from mainframes automatically.

Postby Robert Sample » Mon Jun 05, 2017 11:46 pm

First, there is no such thing as a "COBOL mainframe". A mainframe can execute COBOL, but IBM mainframes are called system z because it is entirely possible for them to be installed and run for years without ever having a single line of COBOL on them. In fact, for a number of years z/OS.e was available on IBM mainframes and it did not support COBOL compilation.

Second, yes the process you described can be automated. Run the query with the output going into a data set (mainframes do not have files except in very limited circumstances; they have data sets instead), have the data sets sent to a server (via FTP is the usual way), and have one or more Excel macros to import the data (depending upon the precise requirements, an additional step to convert the data into comma-delimited records may be necessary). Use the mainframe job scheduler (most sites have purchased a job scheduler) to schedule the query execution at an appropriate time each day.

Of course, making 80-85% of your COBOL programmers redundant may not be a career-enhancing move (unless you work for the company and the programmers work for a contracting / consulting company hired by your company).

Return to “Other Mainframe Topics, Off-Topics, FAQs.”

Who is online

Users browsing this forum: CommonCrawl [Bot] and 2 guests