CN112114817B

CN112114817B - COBOL language-based data dictionary field information acquisition method and device

Info

Publication number: CN112114817B
Application number: CN202011038733.6A
Authority: CN
Inventors: 王鹏飞
Original assignee: Bank of China Ltd
Current assignee: Bank of China Ltd
Priority date: 2020-09-28
Filing date: 2020-09-28
Publication date: 2023-09-19
Anticipated expiration: 2040-09-28
Also published as: CN112114817A

Abstract

The application discloses a method and a device for acquiring field information of a data dictionary based on COBOL language, wherein the method comprises the following steps: acquiring source code information of a data dictionary to be analyzed; compiling the data dictionary in the source code information of the data dictionary to be analyzed to generate a compiling log; extracting field attribute information in the compiling log according to COBOL language variable rules, wherein the field attribute information comprises: length data, start position data, and end position data of the field. The whole working flow of the application is not needed to be manually participated, is automatically completed, and has higher working efficiency.

Description

COBOL language-based data dictionary field information acquisition method and device

Technical Field

The application relates to the technical field of computers, in particular to a method and a device for acquiring field information of a data dictionary based on COBOL language.

Background

On a ZOS platform, data is typically in units of rows, each row of files having a data length, and likewise, data processing in COBOL (Common Business-oriented language) is also in units of rows. Typically, a line of data is a complete unit of data (except for a conventional interface in a bank card system, which uses multiple lines to compose a transaction for historical reasons). The data is simply stored in the computer, the data file does not contain the parsing of each field, and the parsing exists in a data dictionary defined in COYBOOOK, wherein COYBOOOK is a code segment of COBOL, COPY command operation is used in COBOL language, and the code segment is imported into the program in the compiling stage, so that the code reuse efficiency can be improved.

In the prior art, in the process of developing and testing a product, a data dictionary in COPYBOOK is often checked first, the offset and the variable length of a certain variable are calculated according to variable definitions in the dictionary, and then the offset and the variable length are positioned in a file by using manpower or software to acquire data contents. Therefore, a great deal of time is spent to calculate the offset and the variable length, and the whole workflow has lower automation degree and lower working efficiency.

Disclosure of Invention

The embodiment of the application provides a COBOL language-based data dictionary field information acquisition method, which is free from manual participation in the whole workflow and is automatically completed, and has higher working efficiency, and the method comprises the following steps:

acquiring source code information of a data dictionary to be analyzed;

compiling the data dictionary in the source code information of the data dictionary to be analyzed to generate a compiling log;

extracting field attribute information in the compiling log according to COBOL language variable rules, wherein the field attribute information comprises: length data, start position data, and end position data of the field.

Optionally, the method further comprises:

and cleaning the compiled log.

Optionally, after extracting the field attribute information in the compiled log according to COBOL language variable rules, the method further includes:

and carrying out reverse analysis and restoration on the compiling log to obtain field variable type information in a data dictionary.

Optionally, the method further comprises:

and formatting and outputting the field attribute information in the compiling log.

The embodiment of the application also provides a COBOL language-based data dictionary field information acquisition device, the whole workflow is not needed to be manually participated, the whole workflow is automatically completed, and the working efficiency is higher, and the device comprises:

the information acquisition module is used for acquiring source code information of the data dictionary to be analyzed;

the compiling module is used for compiling the data dictionary in the source code information of the data dictionary to be analyzed so as to generate a compiling log;

the information extraction module is used for extracting field attribute information in the compiling log according to COBOL language variable rules, wherein the field attribute information comprises: length data, start position data, and end position data of the field.

Optionally, the apparatus further includes:

and the cleaning module is used for cleaning the compiled log.

Optionally, the apparatus further includes:

and the reverse analysis module is used for carrying out reverse analysis and restoration on the compiling log to acquire field variable type information in the data dictionary.

Optionally, the apparatus further includes:

and the formatting output module is used for formatting and outputting the field attribute information in the compiling log.

The embodiment of the application also provides computer equipment, which comprises a memory, a processor and a computer program stored on the memory and capable of running on the processor, wherein the processor realizes the method when executing the computer program.

Embodiments of the present application also provide a computer-readable storage medium storing a computer program for executing the above method.

According to the embodiment of the application, the source code information of the data dictionary to be analyzed is obtained, the data dictionary in the source code information of the data dictionary to be analyzed is compiled to generate the compiling log, the field attribute information in the compiling log is extracted according to the COBOL language variable rule, the data content can be obtained in the process of developing and testing the product, the whole workflow is not needed to be manually participated, and the whole workflow is automatically completed, so that the working efficiency is high.

Drawings

In order to more clearly illustrate the embodiments of the application or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art. In the drawings:

FIG. 1 is a flowchart of a method for acquiring field information of a COBOL-based data dictionary in an embodiment of the present application;

FIG. 2 is a flowchart illustrating a process of cleaning a compiled log according to an embodiment of the present application;

FIG. 3 is a flowchart of a method for formatting and outputting field attribute information in a compiled log according to an embodiment of the present application;

FIG. 4 is a schematic diagram of a device for obtaining field information of a COBOL-based data dictionary in an embodiment of the present application;

FIG. 5 is a schematic diagram illustrating a structure of a log for cleaning according to an embodiment of the present application;

FIG. 6 is a schematic diagram of a structure of formatting output of field attribute information in a compiled log according to an embodiment of the present application;

FIG. 7 is a diagram showing a specific example of field attribute information according to an embodiment of the present application;

FIG. 8 is a specific example diagram of a COBOL language-based data dictionary field information acquisition method in an embodiment of the present application;

FIG. 9 is a schematic diagram of a computer device according to an embodiment of the application.

Detailed Description

For the purpose of making the objects, technical solutions and advantages of the embodiments of the present application more apparent, the embodiments of the present application will be described in further detail with reference to the accompanying drawings. The exemplary embodiments of the present application and their descriptions herein are for the purpose of explaining the present application, but are not to be construed as limiting the application.

The names involved in the present application are explained below:

ZOS host platform A Z-series server operating system platform of IBM product, unlike other computer architectures, uses specialized architecture, CUP, motherboard chip and operating system, and the current ZOS is an extended extension of OS360 system in 1964.

COBOL: common Business-Oriented Language, a Business-oriented general-purpose language, was the first generation of advanced programming language in the world, and was born in 1959, mainly serving Business and financial systems. Generally, COBOL language is a unit of processing for a file in units of lines.

COPYBOOK: COBOL code fragments, which are used in COBOL language to import the code fragments into program during compiling stage, can raise code reuse efficiency. Generally, encapsulated in COPYBOOK are some code fragments having a common meaning, such as data dictionary parsing of a file or a piece of logic code that can be encapsulated as a subroutine. Typically, COPYBOOK is used to store data dictionary parsing of a file, which is also a specific example of a "data dictionary" described herein.

Variable length: the amount of space (typically in bytes) that a variable occupies, the amount of space occupied by different types of variables varies. For COBOL languages, typically an X-type character (alphanumeric, e.g., variable X (1)) and a 9-type character (numeric, e.g., variable 9 (1)) occupy one byte, a binary-type variable (COMP, e.g., variable 9 (N) COMP) occupies 2 bytes (when N e [1,4 ]), 4 bytes (when N e [5,9 ]), 8 bytes (when N e [10,18 ]), and a packed decimal-type variable (COMP-3, e.g., variable 9 (N) COMP-3) occupies ([ (n+1)/2 ] +1) bytes (where N is a defined number of digits of the variable, [ ] represents an integer portion that takes the value).

Offset amount: the position of a code, or data field, relative to the head of a line (typically the first bit of the line starting from the left), is typically used to describe the machine language. For example, the offset of field a3 in file a is 56, which means that field a3 starts in file a at column 56, also called the location.

JCL: job Control Language, the job control language, also called CNTL for short, is a script of the IBM host (z-series server) to enable interaction with the system.

JOB: the job, the smallest unit of execution of a task on the host, corresponds to the concept of a process. Generally, a JCL that commits to run is a JOB, a process. The compilation of the program is also a JOB.

Compiling a log: in the process of compiling the COBOL program into binary code, various information in the compiling process, including some detailed information required when the program is compiled into assembly language, memory addresses of various variables are generated, and memory is loaded into the memory by establishing various register entry allocation tables. It is important for the present application to calculate the length and offset of each variable.

SPOOL: simultaneous Peripheral Operation On-Line, which is a technology about how slow character devices exchange information with computing hosts, is often referred to as "spooling" technology. The SPOOLing technology is effectively a peripheral device simultaneous on-line operation technology, also known as a queuing and storage technology, which is similar to a buffer zone in that input and output are added with queuing and output links of an input well and an output well. For example, in the Windows platform SPOOLing is commonly used for buffers between computers and printers. JOB information that has been submitted to be run, running, and running on the ZOS platform is stored in the JOB queue system, which includes a compilation log of the program.

COBOL variable layering: COBOL variables are generally divided into combined terms and independent terms. Similar to the structural variables in the C language, where the individual terms correspond to members thereof, the combined terms correspond to the structure. Except that the combined term in COBOL may exist under another combined term, so there is a unique variable hierarchy relationship in COBOL language, the highest hierarchy is 01 layers, the lowest hierarchy is 49 layers, that is, COBOL language may have 49 layers at most (48 layers contain combined term layer by layer, and the bottom 49 layers are independent terms). The combined item must contain an independent item, which is the most basic unit of stored data. In addition, COBOL language has special 66-layer, 77-layer and 88-layer variables, which are different from 01-49-layer variables in use and definition.

Fig. 1 is a flowchart of a method for obtaining field information of a COBOL-based data dictionary according to an embodiment of the present application, as shown in fig. 1, where the method includes:

and 101, acquiring source code information of a data dictionary to be analyzed.

In an embodiment, the source code information of the data dictionary to be analyzed may be: a list of data dictionary listings requiring a single analysis or a source code library of data dictionaries requiring all analyses.

And 102, compiling the data dictionary in the source code information of the data dictionary to be analyzed to generate a compiling log.

In the implementation, parameters of the JCL interface can be called to realize processing for a determined single data dictionary list to be analyzed, processing can also be performed for a certain data dictionary source code library, the processing mode is parallel processing, and each source code can generate a compiling operation and further generate a compiling log.

Step 103, extracting field attribute information in the compiling log according to COBOL language variable rules, wherein the field attribute information comprises: length data, start position data, and end position data of the field.

As shown in fig. 7, the first frame from left to right is the start position (offset position) of the variable; the second frame from left to right is the data dictionary list itself for reference; the third box from left to right, like the first box, is also the starting position of the variable; the fourth box from left to right is the length of the variable; the fifth box from left to right is the end position of the variable.

As can be seen from fig. 1, according to the method for acquiring field information of a COBOL language-based data dictionary provided by the embodiment of the application, by acquiring source code information of a data dictionary to be analyzed, compiling the data dictionary in the source code information of the data dictionary to be analyzed to generate a compiling log, extracting field attribute information in the compiling log according to COBOL language variable rules, and acquiring data content in the process of developing and testing a product, the whole workflow is not required to be manually participated, and the whole workflow is automatically completed, so that the working efficiency is high.

FIG. 2 is a flowchart illustrating a process of cleaning a compiled log according to an embodiment of the present application, where, as shown in FIG. 2, the method further includes:

step 201, cleaning the compiled log.

In specific implementation, the compiling log (that is, the JOB information submitted in the scope) may be cleaned according to a preset script, and it should be noted that after the compiling processing is performed on the data dictionary in the source code information of the data dictionary to be analyzed, the compiling log is output to the scope, so as to release system resources and keep the working environment clean. Fig. 8 is a specific example diagram of a COBOL-based data dictionary field information acquisition method.

In order to facilitate the subsequent staff to check the field variable types in the data dictionary, so as to analyze the data, after extracting the field attribute information in the compiling log according to the COBOL language variable rule, the method further comprises:

In specific implementation, the compiling LOG can be reversely analyzed and restored according to COBOL language variable rules, and then intelligent text analysis and reverse analysis algorithm of COBOL compiling LOG can be achieved.

Fig. 3 is a flowchart of formatting and outputting field attribute information in a compiled log according to an embodiment of the present application, in order to lay a foundation for subsequent data analysis, as shown in fig. 3, the method further includes:

and 301, carrying out formatting output on field attribute information in the compiling log.

Based on the same inventive concept, the embodiment of the application also provides a data dictionary field information acquisition device based on COBOL language, as described in the following embodiment. The principle of the COBOL-based data dictionary field information acquisition device for solving the problem is similar to that of the COBOL-based data dictionary field information acquisition method, so that the implementation of the COBOL-based data dictionary field information acquisition device can be referred to the implementation of the COBOL-based data dictionary field information acquisition method, and repeated parts are omitted. As used below, the term "unit" or "module" may be a combination of software and/or hardware that implements the intended function. While the means described in the following embodiments are preferably implemented in software, implementation in hardware, or a combination of software and hardware, is also possible and contemplated.

Fig. 4 is a schematic structural diagram of a COBOL language-based data dictionary field information obtaining device according to an embodiment of the present application, where, as shown in fig. 4, the device includes:

an information acquisition module 401, configured to acquire source code information of a data dictionary to be analyzed;

the compiling module 402 is configured to compile a data dictionary in source code information of the data dictionary to be analyzed to generate a compiling log;

the information extraction module 403 is configured to extract field attribute information in the compiled log according to COBOL language variable rules, where the field attribute information includes: length data, start position data, and end position data of the field.

Fig. 5 is a schematic structural diagram of a processing for cleaning a compiled log according to an embodiment of the present application, where, as shown in fig. 5, the apparatus further includes:

the cleaning module 501 is configured to perform cleaning processing on the compiled log.

In an embodiment of the present application, the apparatus further includes:

Fig. 6 is a schematic structural diagram of formatting and outputting field attribute information in a compiled log according to an embodiment of the present application, where, as shown in fig. 6, the apparatus further includes:

and the formatting output module 601 is configured to perform formatting output on the field attribute information in the compiling log.

To achieve the above object, according to another aspect of the present application, there is also provided a computer apparatus. As shown in fig. 9, the computer device includes a memory, a processor, a communication interface, and a communication bus, where a computer program executable on the processor is stored on the memory, and when the processor executes the computer program, the steps in the method of the above embodiment are implemented.

The processor may be a central processing unit (Central Processing Unit, CPU). The processor may also be any other general purpose processor, digital signal processor (Digital Signal Processor, DSP), application specific integrated circuit (Application Specific Integrated Circuit, ASIC), field programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic device, discrete gate or transistor logic, discrete hardware components, or any combination thereof.

The memory is used as a non-transitory computer readable storage medium for storing non-transitory software programs, non-transitory computer executable programs, and units, such as corresponding program units in the above-described method embodiments of the application. The processor executes the various functional applications of the processor and the processing of the composition data by running non-transitory software programs, instructions and modules stored in the memory, i.e., implementing the methods of the method embodiments described above.

The memory may include a memory program area and a memory data area, wherein the memory program area may store an operating system, at least one application program required for a function; the storage data area may store data created by the processor, etc. In addition, the memory may include high-speed random access memory, and may also include non-transitory memory, such as at least one magnetic disk storage device, flash memory device, or other non-transitory solid state storage device. In some embodiments, the memory may optionally include memory located remotely from the processor, the remote memory being connectable to the processor through a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.

The one or more units are stored in the memory, which when executed by the processor, performs the method in the above embodiments.

In summary, according to the method and the device, the source code information of the data dictionary to be analyzed is obtained, the data dictionary in the source code information of the data dictionary to be analyzed is compiled to generate the compiling log, the field attribute information in the compiling log is extracted according to the COBOL language variable rule, the data content can be obtained in the process of developing and testing the product, the whole workflow is not needed to be manually participated, and the whole workflow is automatically completed, so that the working efficiency is high.

In addition, the application has the following advantages:

1. all data dictionaries can be processed in parallel in a batch dynamic mode, tedious manual operation is avoided, and working efficiency is improved.

2. The method can intelligently analyze the compiled LOGs, directly acquire the offset and the field length of all the fields in the LOGs, reversely analyze the compiled LOGs and display the definition information and the hierarchical relationship of the fields.

3. All of these results can be formatted and output and can be imported directly into EXCEL as part of document management as the basis for file parsing.

4. The application is accompanied with a SPOOL analytic log cleaning mechanism to release system resources.

It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.

The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

The foregoing description of the embodiments has been provided for the purpose of illustrating the general principles of the application, and is not meant to limit the scope of the application, but to limit the application to the particular embodiments, and any modifications, equivalents, improvements, etc. that fall within the spirit and principles of the application are intended to be included within the scope of the application.

Claims

1. The COBOL language-based data dictionary field information acquisition method is characterized by comprising the following steps of:

acquiring source code information of a data dictionary to be analyzed;

extracting field attribute information in the compiling log according to COBOL language variable rules, wherein the field attribute information comprises: length data, start position data, and end position data of the field;

the source code information of the data dictionary to be analyzed is: a list of data dictionary lists requiring a single analysis or a source code library of data dictionary requiring all analysis;

compiling the data dictionary in the source code information of the data dictionary to be analyzed to generate a compiling log, comprising:

invoking parameters of the JCL interface to realize processing aiming at a determined single data dictionary list to be analyzed; or processing a data dictionary source code library in parallel, wherein each source code generates a compiling job and further generates a compiling log.

2. The method as recited in claim 1, further comprising:

and cleaning the compiled log.

3. The method of claim 1, wherein after extracting field attribute information in the compilation log according to COBOL language variable rules, the method further comprises:

4. The method as recited in claim 1, further comprising:

5. A COBOL language-based data dictionary field information acquisition apparatus, comprising:

the information extraction module is used for extracting field attribute information in the compiling log according to COBOL language variable rules, wherein the field attribute information comprises: length data, start position data, and end position data of the field;

6. The apparatus as recited in claim 5, further comprising:

and the cleaning module is used for cleaning the compiled log.

7. The apparatus of claim 5, wherein the apparatus further comprises:

8. The apparatus as recited in claim 5, further comprising:

9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method of any of claims 1 to 4 when executing the computer program.

10. A computer readable storage medium, characterized in that the computer readable storage medium stores a computer program for executing the method of any one of claims 1 to 4.