且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

您如何使用任何编程语言将数据从大型机系统导出到Excel

更新时间:2022-11-07 17:16:29

什么牌子的大型机?什么操作系统?哪个文件管理系统(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?