CN103309678A - Method for processing data in combined environment of IBM mainframe - Google Patents
Method for processing data in combined environment of IBM mainframe Download PDFInfo
- Publication number
- CN103309678A CN103309678A CN2013102698742A CN201310269874A CN103309678A CN 103309678 A CN103309678 A CN 103309678A CN 2013102698742 A CN2013102698742 A CN 2013102698742A CN 201310269874 A CN201310269874 A CN 201310269874A CN 103309678 A CN103309678 A CN 103309678A
- Authority
- CN
- China
- Prior art keywords
- data
- ibm
- legacy system
- worksheet
- intermediate interface
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method for processing data in a combined environment of an IBM mainframe. Firstly, an intermediate interface having target column information is designed by using an Excel worksheet; then, an Excel micro is compiled to enable a user to output logging data into another worksheet and save the worksheet while finishing recording each piece of data; finally, the accumulated data guided into the worksheet by an IBM Personal Communicator micro are compiled, and data in a legacy system are automatically recorded according to the target column information. The legacy system does not need to be changed at all in the process, no risk is added, the process of processing the data in the legacy system is automatically completed, the processing efficiency is high, the operation is simple, the advantages of convenience in use and safety and reliability are achieved, and the method is particularly applicable to the combined environment of the IBM mainframe in a financial system of a bank or insurance company.
Description
Technical field
The present invention relates to a kind of immediate processing method of data information, particularly a kind of raising data in new business system and the mixed structure environment of the big-and-middle-sized machine Legacy System of IBM is processed the method for efficiency of inputting.
Background technology
IBM Personal Communicator is the textual interface terminal software that the usefulness of IBM distribution visits IBM large scale computer operating system OS/390 and the medium-sized machine operation AS/400 of system.The application that much operates in OS/390 and AS/400 all only provides textual interface, and the user connects the said system access application by IBM Personal Communicator, inputs or obtain data.
Microsoft Office Excel is the worksheet instrument in the office suite of Microsoft distribution.
Grand, be a series of high-level programming languages that provided support by different software self, grand grammer and function are different because of support software.But most of macrolanguage can be called some functions that software self provides, so that developer or user can utilize macrolanguage to carry out some exploitations, reduces the operation of user on software interface or menu, accelerates issued transaction speed.For example the macrolanguage that provides of Microsoft Office Excel software can allow in access in the program and change content in the worksheet, imports and exports other worksheets or file etc.IBM Personal Communicator equally also supports macroefficiency, and the field of the application of OS/390 and the operation of AS/400 lane terminal, the functions such as reading external data file can be accessed, be revised to the macrolanguage that it provides.
COBOL is the main programming language that carries out software development on the IBM large scale computer operating system OS/390, is widely used in the programming development of different application on OS/390.RPG is the main programming language that carries out software development on the medium-sized machine operation AS/400 of system of IBM, is widely used in the programming development of different application on AS/400.But because OS/390 or AS/400 are not the general-purpose operating systems, so it is few than other programming languages to grasp the developer of COBOL or RPG, the Object-Oriented Programming Languages such as Java and C++ are difficult to grasp and safeguard relatively.
In large bank, operation system newly developed is often with Legacy System (Legacy System) and deposit.And in the Legacy System take the big-and-middle-sized machine Legacy System of IBM as main, the principal feature of these systems is: use COBOL develops and operates in OS/390 operating system and the use RPG exploitation of IBM large scale computer zSeries and operates on the AS/400 operating system of medium-sized machine iSeries, and the user need use IBM Personal Communicator to access the terminal carrying out service processing of textual interface.These systems are the core system of bank often, has concentrated core application and core data, has performance high, and handling capacity is large, the construction time early, the characteristics such as ease for maintenance is low.But these Legacy Systems are highly stable and extremely important, for avoiding producing loss and bear unnecessary responsibility, bank can not change its system easily, and at the periphery of these Legacy Systems, because business development needs and flow scheme improvements, new operation system constantly occurs, and need to dock with Legacy System in user level.As: for the image Workflow system of processing bank's declaration form, the user need to be input in the declaration form scanned copy data that in the Workflow system front end scanned up and concentrate in the insurance business Legacy System and process, because the declaration form design changes often, so the data on the declaration form scanned copy are not corresponding with the data field major part in the insurance business Legacy System, cause the Data Processor need to possess more deep professional knowledge, could be mapped both, and constantly in the different interfaces of insurance business Legacy System, constantly change the corresponding field of searching and input, just can finish the data work for the treatment of.This flow process is not only lost time, and has increased the time of Data Processor's training and the difficulty of work outsourcing.
A method that addresses this problem is to update Legacy System, and core and the interface of for example using COBOL or RPG programming language to remove to revise Legacy System make it constantly to adapt to the demand that front-end business changes.But because the risk that maintenance difficulties, huge testing cost and the renewal of Legacy System bring, the Legacy System so that bank is unwilling arbitrarily to change, and would rather stand the inconvenience that update system is not brought, perhaps seeking other method improves the efficient that typing is upgraded, with the reply present case.
So, design a kind of new method, under the prerequisite that does not change original Legacy System, Effective Raise data information treatment effeciency guarantee to be processed security, wants the problem that solves with regard to becoming the present invention.
Summary of the invention
In view of above-mentioned existing situation, but the present invention aim to provide a kind of in the mixed structure environment of new business system and the big-and-middle-sized machine Legacy System of IBM the Effective Raise data process the method for efficiency of inputting, to realize safe, efficient new business number pick arrangement and storage, simplify processing procedure, reduce the professional requirement of understanding the Data Processor.
The present invention is Song Shixian by the following technical programs:
A kind of data processing method in the mixed structure environment of the big-and-middle-sized machine of IBM comprises:
Step 1, the intermediate interface that design is suitable for according to system requirements use Excel worksheet add corresponding target field information in intermediate interface; Described target field information is the field information in the corresponding Legacy System, comprises at least page number and field position.
Step 2, make the user after intermediate interface is finished every data typing, export simultaneously logging data in another Zhang Gong's tabulation by writing excel macro, and preserve.
After step 3, intermediate interface typing are finished, enter IBM Personal Communicator, write the data of accumulating in the grand importing worksheet of IBM Personal Communicator, and the respective interface that root pick target field information enters in the Legacy System automatically finishes the data automatic input, and the data in the mixed structure environment of the big-and-middle-sized machine of IBM is finished dealing with.
Also comprise in the described above-mentioned processing procedure: in intermediate interface, add the field check information, the tag name of target field on Legacy System for example, when automatically entering respective interface in the Legacy System according to target field information when finishing the data automatic input, at first judge the field check information, to determine whether field was once changed by system, and for example label changes, this field may reality be replaced by another field, no, then continue typing; Be, then eject warning window prompting intermediate interface and may upgrade in response to the change of Legacy System, then enter next target bit continuation typing according to the prompting Select input or after withdrawing from.Do not get rid of for some reason Legacy System this moment and after the intermediate interface exploitation is finished, made change, after this situation might occur in intermediate interface when using one section, Legacy System is because application upgrade causes the target field to change, but these change because a variety of causes fails to reflect in intermediate interface, and this moment, verifying function can prevent that data are by wrong typing.
A kind of data processing method in the mixed structure environment of the big-and-middle-sized machine of IBM of the present invention, it is take the macroefficiency of the macroefficiency of Microsoft Office Excel and IBM Personal Communicator as the basis, utilize respective objects field information that intermediate interface adds and field check information and worksheet specifically to count the pick operation store, finished the data processing procedure of the big-and-middle-sized machine of IBM in the mixed structure environment.Because revising intermediate interface is very easy to, so data is processed the interface and also is very easy to safeguard, do not needing that Legacy System is done any change, when not increasing risk, guaranteed that the robotization of data processing procedure is finished on the Legacy System, the data treatment effeciency significantly improves, and has reduced professional understanding to Data Processor's requirement.Whole method is simple to operate, easy to use, practical, data preparation storing process safety, reliable, both do not increased more cost, effectively avoided security risk yet, and be particularly suitable in the big-and-middle-sized machine of the IBM of the financial sectors such as bank, insurance system, using.
Embodiment
Center of the present invention is the data processing procedure of simplifying in the mixed structure environment, utilize macrolanguage to finish series connection between Microsoft Office Excel and IBM Personal Communicator, form the automatic importing process of number pick under the controllable state, finish the efficient typing of number pick.The below is described in further detail the present invention:
A kind of data processing method in the mixed structure environment of the big-and-middle-sized machine of IBM of the present invention comprises:
Step 1, according to the requirement of the big-and-middle-sized machine Legacy System of IBM, use the applicable intermediate interface of Excel worksheet design, and in intermediate interface, add corresponding target field information and field check information.
Wherein, target field information is the field information in the corresponding Legacy System, and it comprises page number and field position at least.The field check information is that target field state is carried out verification, to determine whether the target field has been modified or typing.
Step 2, make the user after intermediate interface is finished every data typing, export simultaneously logging data in another Zhang Gong's tabulation by writing excel macro, and preserve.Worksheet exists as a unloading station in the data typing.
After step 3, intermediate interface typing are finished, enter IBM Personal Communi cator, write the data of accumulating in the grand importing worksheet of IBM Personal Communicator, and root pick target field information and field check information automatically enter in the respective interface in the Legacy System target field are judged, whether once changed by system to determine field, for example label changes, and this field may reality be replaced by another field.Be modified such as the target field, then needing to eject warning message prompting intermediate interface may upgrade in response to the change of Legacy System, after this situation usually occurs in intermediate interface when using one section, Legacy System is because application upgrade causes the target field to change, but these change because a variety of causes fails to reflect in intermediate interface, and this moment, verifying function can prevent that data are by wrong typing; Be not modified such as the target field, then directly typing.
So far, the data processing procedure in the mixed structure environment of the big-and-middle-sized machine of whole IBM is finished automatically.
Certainly, the checking procedure of above-mentioned field check information also can be replaced by the assurance process of the existence of other checking mechanism or maintenance process, has simplified design and the renewal of intermediate interface, is not described in detail in this.
Claims (2)
1. the data processing method in the mixed structure environment of the big-and-middle-sized machine of IBM is characterized in that, comprising:
Step 1, root pick system requirements use the applicable intermediate interface of Excel worksheet design, add corresponding target field information in intermediate interface; Described target field information is the field information in the corresponding Legacy System, comprises at least page number and field position;
Step 2, make the user after intermediate interface is finished every data typing, export simultaneously logging data in another Zhang Gong's tabulation by writing excel macro, and preserve;
After step 3, intermediate interface typing are finished, enter IBM Personal Communicator, write the number pick of accumulating in the grand importing worksheet of IBM Personal Communi cator, and finish the data automatic input according to the respective interface that target field information enters in the Legacy System automatically, the data in the mixed structure environment of the big-and-middle-sized machine of IBM is finished dealing with.
2. a kind of data processing method in the mixed structure environment of the big-and-middle-sized machine of IBM according to claim 1, it is characterized in that, also comprise in the described above-mentioned steps: in intermediate interface, add the field check information, when automatically entering respective interface in the Legacy System according to target field information when finishing the data automatic input, at first judge the field check information, to determine whether this field was once changed by system, no, then continue typing; Be, then eject warning window, and root pick prompting Select input or withdraw from after enter next target bit and continue typing.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310269874.2A CN103309678B (en) | 2013-07-01 | 2013-07-01 | A kind of data processing method in the mixed structure environment of the big-and-middle-sized machine of IBM |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310269874.2A CN103309678B (en) | 2013-07-01 | 2013-07-01 | A kind of data processing method in the mixed structure environment of the big-and-middle-sized machine of IBM |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103309678A true CN103309678A (en) | 2013-09-18 |
| CN103309678B CN103309678B (en) | 2016-06-15 |
Family
ID=49134939
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310269874.2A Active CN103309678B (en) | 2013-07-01 | 2013-07-01 | A kind of data processing method in the mixed structure environment of the big-and-middle-sized machine of IBM |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103309678B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104239047A (en) * | 2014-10-13 | 2014-12-24 | 深圳市神州海纳科技有限公司 | Information acquisition method and device thereof |
| CN112772474A (en) * | 2021-03-10 | 2021-05-11 | 南开大学 | Hexagrammos otakii population dynamic DEB-IBM model and modeling method |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101261584A (en) * | 2008-04-24 | 2008-09-10 | 北京科翰软件有限公司 | Presentation layer middleware system based on Office document |
| CN103082630A (en) * | 2011-11-02 | 2013-05-08 | 高洪祥 | Modified cosmetic case |
-
2013
- 2013-07-01 CN CN201310269874.2A patent/CN103309678B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101261584A (en) * | 2008-04-24 | 2008-09-10 | 北京科翰软件有限公司 | Presentation layer middleware system based on Office document |
| CN103082630A (en) * | 2011-11-02 | 2013-05-08 | 高洪祥 | Modified cosmetic case |
Non-Patent Citations (2)
| Title |
|---|
| 夏慧恒等: "《基于SCADA数据的地区电网无功优化计算软件》", 《农村电气化》 * |
| 罗胜涛: "《报表组件中向模板填充数据的优化方法》", 《计算机工程》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104239047A (en) * | 2014-10-13 | 2014-12-24 | 深圳市神州海纳科技有限公司 | Information acquisition method and device thereof |
| CN104239047B (en) * | 2014-10-13 | 2017-10-24 | 深圳市神州海纳科技有限公司 | The method and its device of a kind of information gathering |
| CN112772474A (en) * | 2021-03-10 | 2021-05-11 | 南开大学 | Hexagrammos otakii population dynamic DEB-IBM model and modeling method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103309678B (en) | 2016-06-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107391653B (en) | Distributed NewSQL database system and picture data storage method | |
| CN102934114B (en) | For the checkpoint of file system | |
| US7921330B2 (en) | Data migration manager | |
| US20170236130A1 (en) | Emulating Manual System of Filing Using Electronic Document and Electronic File | |
| CN106776515A (en) | The method and device of data processing | |
| CN101458705A (en) | Data collating method between different utility systems, apparatus and system | |
| US20170228356A1 (en) | System Generator Module for Electronic Document and Electronic File | |
| CN102402505B (en) | Delta language translation method and system | |
| CN107358525B (en) | Account transaction method and device | |
| CN103593257A (en) | Data backup method and device | |
| CN113312108A (en) | SWIFT message checking method and device, electronic equipment and storage medium | |
| CN114925084A (en) | Distributed transaction processing method, system, device and readable storage medium | |
| US20120246551A1 (en) | Updating serialized objects | |
| CN109426496A (en) | Method, storage medium, electronic equipment and the system of program log write-in file | |
| CN104123104B (en) | Daily record control system and method | |
| CN103309678A (en) | Method for processing data in combined environment of IBM mainframe | |
| US20080010632A1 (en) | Processing large sized relationship-specifying markup language documents | |
| US20080313472A1 (en) | Method and apparatus for changing and adding activation keys for functions of digital content without having to change and recompile the digital content | |
| CN111475150B (en) | Cross-language binding method, device, equipment and storage medium | |
| CN106503027B (en) | Database operation method and device | |
| JP5837898B2 (en) | Information processing apparatus, information processing method, and program | |
| CN103530353B (en) | Self-identification method of GPS user data format | |
| CN103034652A (en) | Method and system for analyzing and processing data | |
| CN109426702A (en) | IOS platform file reads guard method, storage medium, electronic equipment and system | |
| CN102622297A (en) | Method for generating test cases for fuzz tool aiming at com component derivative function parameter space and binary data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |