您如何使用任何编程语言将数据从大型机系统导出到Excel [英] How do u export data from Mainframe system to Excel using any programming language

问题描述

我正在寻找一种将从大型机系统中提取数据并将其导出到excel并进行排序的技术.所有这些都需要通过单击按钮来实现.

解决方案

什么牌子的大型机?什么操作系统?哪个文件管理系统(IMS，DB2?旧的ISAM?)您是否必须经过仿真的终端连接，还是可以安排文件传输?他们在使用WAS吗? WebSphere MQ?您可以在大型机上执行事务吗?如果可以，那是什么类型? CICS?
解决了这些问题后，您可以去寻找一款商业应用程序(它可能会便宜一些，这些大型机客户习惯于支付高价)
您在哪里单击此单个按钮?您有大型机鼠标吗?

I''m looking for a technique wherein the data from the mainframe system will be extracted and exported to excel and sorted. All this needs to happen with a button click.

解决方案

What brand mainframe? What Operating System? Which File management System (IMS, DB2? Plain old ISAM?) Do you have to go over emulated terminal connections, or can a file transfer be arranged? Are they using WAS? WebSphere MQ? Can you implement transactions on the mainframe, if yes what kind? CICS?
Once you''ve sorted that out you can go look for a commercial App (which probably won''t come cheap, These Mainframe customers are used to paying top prices)
Where do you click this single button? Do you have a mainframe mouse?

这篇关于您如何使用任何编程语言将数据从大型机系统导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！