CN112114817A

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

Info

Publication number: CN112114817A
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: 2020-12-22
Anticipated expiration: 2040-09-28
Also published as: CN112114817B

Abstract

The invention discloses a method and a device for acquiring field information of a data dictionary based on a 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; according to the COBOL language variable rule, extracting field attribute information in the compiling log, wherein the field attribute information comprises: length data, start position data, and end position data of the fields. The whole working process of the invention does not need manual participation, and the whole process is automatically completed, and the working efficiency is higher.

Description

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

Technical Field

The invention 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 a COBOL language.

Background

On a ZOS platform, data is generally in a unit of line, each line of file has a data length, and similarly, data processing in COBOL (Common Business-Oriented Language) is also in a unit of line. Typically, a line of data is a complete unit of data (except for the traditional interface in bankcard systems, which historically uses multiple lines to form a transaction). The data is stored in the computer simply, the data file does not contain the analysis of each field, and the analysis exists in the data dictionary of COPYBOOK, wherein COPYBOOK is the code fragment of COBOL, and the COPY command operation is used in COBOL language for importing the code fragment into the program in the compiling stage, thereby improving the code reuse efficiency.

In the prior art, in the process of developing and testing a product, a data dictionary in copy book is often checked first, the offset and the variable length of a certain variable are calculated according to the variable definition in the data dictionary, and then positioning is performed in a file by using manpower or software to obtain data content. Therefore, a large amount of time is not needed to be spent on calculating the offset and the variable length, the automation degree of the whole workflow is low, and the working efficiency is low.

Disclosure of Invention

The embodiment of the invention provides a method for acquiring field information of a data dictionary based on a COBOL language, which has the advantages that the whole working process is not manually participated, the whole working process is automatically completed, and the working efficiency is higher, 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;

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

Optionally, the method further includes:

and cleaning the compiling log.

Optionally, after extracting the field attribute information in the compilation log according to a COBOL language variable rule, the method further includes:

and performing reverse analysis and reduction on the compiling log to obtain field variable type information in a data dictionary.

Optionally, the method further includes:

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

The embodiment of the invention also provides a device for acquiring the field information of the data dictionary based on the COBOL language, the whole work flow does not need manual participation, all the work is automatically completed, the work 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;

an information extraction module, configured to extract field attribute information in the compilation log according to a COBOL language variable rule, where the field attribute information includes: length data, start position data, and end position data of the fields.

Optionally, the apparatus further comprises:

and the clearing module is used for clearing the compiling log.

Optionally, the apparatus further comprises:

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

Optionally, the apparatus further comprises:

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

The embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor implements the method when executing the computer program.

An embodiment of the present invention further provides a computer-readable storage medium, in which a computer program for executing the above method is stored.

In the embodiment of the invention, the data dictionary in the source code information of the data dictionary to be analyzed is compiled by acquiring the source code information of the data dictionary to be analyzed to generate the compiling log, and the field attribute information in the compiling log is extracted according to the COBOL language variable rule, so that the data content can be acquired in the process of developing and testing the product.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts. In the drawings:

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

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

FIG. 3 is a flowchart illustrating formatting output of field attribute information in a compilation log according to an embodiment of the present invention;

fig. 4 is a schematic structural diagram of a COBOL language-based data dictionary field information acquisition apparatus according to an embodiment of the present invention;

FIG. 5 is a schematic structural diagram illustrating a clearing process performed on a compilation log according to an embodiment of the present invention;

FIG. 6 is a schematic structural diagram illustrating formatted output of field attribute information in a compilation log according to an embodiment of the present invention;

FIG. 7 is a diagram illustrating exemplary field attribute information according to an embodiment of the present invention;

fig. 8 is a diagram illustrating an exemplary embodiment of a method for acquiring field information of a COBOL-based data dictionary according to the present invention;

FIG. 9 is a diagram of a computer device according to an embodiment of the present invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention.

The following explains the names referred to in this application:

a ZOS host platform is a Z-series server operating system platform of IBM products, which is different from other computer architectures, uses a special architecture, a CUP, a mainboard chip and an operating system, and the current ZOS is an extension expansion of a 1964 OS360 system.

COBOL: common Business-Oriented Language, the first high-level programming Language of the world, born in 1959, served primarily by Business and financial systems. Generally, the processing unit of the COBOL language for a file is a unit of a behavior.

COPPYBOOK: COBOL code segments are operated by using a COPY command in a COBOL language and are used for importing the code segments into a program in a compiling stage, so that the code reuse efficiency can be improved. Generally, encapsulated in COPYBOOK are code segments with common meanings, such as a data dictionary resolution of a file or a piece of logic code that can be encapsulated as a subroutine. In general, COPYBOOK is used to store a data dictionary resolution for a file, which is also a specific example of a "data dictionary" described herein.

Variable length: the size of the space occupied by a variable (usually in bytes) varies with the different types of variables. For COBOL language, typically one X-type character (alphanumeric, e.g., variable X (1)) and one 9-type character (numeric, e.g., variable 9(1)) occupy one byte, one binary-type variable (COMP, e.g., variable 9(N) COMP), which occupies 2 bytes (when N ∈ [1,4]), 4 bytes (when N ∈ [5,9]), 8 bytes (when N ∈ [10,18]), respectively, one packed decimal-type variable (COMP-3, e.g., variable 9(N) COMP-3), occupies ([ (N +1)/2] +1) bytes (where N is the defined number of variable bits, [ ] indicates the integer part of the value).

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

JCL: job Control Language, abbreviated as CNTL, is a script of an IBM host (z-series server) to realize interaction with a system.

JOB: a job, the smallest unit of a task executed on a host, corresponds to the concept of a process. In general, a JCL that commits a run is a JOB, a process. Compilation of a program is also a JOB.

Compiling the log: during the process of compiling the COBOL program into the binary code, various information in the compiling process, including some detailed information required when the program is loaded into the memory, such as compiling the program into an assembly language, generating memory addresses of various variables, establishing register entry allocation tables, and the like, is obtained. Where it is important for the present invention that the length and offset of each variable be calculated.

SPOOL: simultaneous Operation On-Line, an external device operating online and in parallel, is a technique On how slow-speed character devices exchange information with a computing host, commonly referred to as "spooling". The spoolin technology is actually a peripheral device simultaneous on-line operation technology, also called a queue-and-dump technology, which adds a queue-and-dump link of an input well and an output well between input and output, similar to a buffer. For example, spoolin is commonly used in the Windows platform for buffers between computers and printers. The JOB information submitted to be run, running and completed on the ZOS platform is stored in a SPOOL queue system, wherein the JOB information comprises a compiling log of the program.

Layering COBOL variables: COBOL variables are generally divided into combinatorial and independent terms. Similar to the structure variable in C language, where the individual terms are equivalent to members thereof and the combination terms are equivalent to the structure. Except that the combinatory items in COBOL can exist under another combinatory item, so that the COBOL language has a specific variable hierarchical relationship, the highest hierarchical level is 01 layers, and the lowest hierarchical level is 49 layers, that is, the COBOL language can have 49 layers at most (48 layers of combinatory items are included layer by layer, and the lowest 49 layers are independent items). The combination item must contain an individual item, which is the most basic unit of storage data. In addition, the COBOL language has special 66-layer, 77-layer and 88-layer variables, which are different from the variables of the 01-49 layers in use and definition.

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

step 101, obtaining 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 a full analysis.

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

In specific implementation, parameters of the JCL interface may be called to implement processing on a determined single data dictionary list to be analyzed, or processing may be performed on a certain data dictionary source code library, a processing mode is parallel processing, and each source code generates a compiling job, thereby generating a compiling log.

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

As shown in fig. 7, the first box from left to right is the start position (offset position) of the variable; the second box 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 ending 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 in the embodiment of the present invention, by acquiring source code information of a to-be-analyzed data dictionary, compiling the data dictionary in the source code information of the to-be-analyzed data dictionary to generate a compilation log, and extracting field attribute information in the compilation log according to a COBOL language variable rule, data content can be acquired in a process of developing and testing a product.

Fig. 2 is a flowchart of performing a cleaning process on a compilation log according to an embodiment of the present invention, and as shown in fig. 2, the method further includes:

step 201, cleaning up the compiling log.

In specific implementation, the compiling log (that is, the JOB information submitted in the SPOOL, it should be noted that after the data dictionary in the source code information of the data dictionary to be analyzed is compiled, the compiling log is output to the SPOOL) may be cleared according to the preset script, so as to release system resources and keep the working environment clean. Fig. 8 is a diagram showing a specific example of a method for acquiring field information of a COBOL-based data dictionary according to the present invention.

In order to facilitate subsequent staff to view field variable types in the data dictionary and analyze data, after extracting field attribute information in the compilation log according to a COBOL language variable rule, the method further includes:

During specific implementation, the compiling LOG can be reversely analyzed and restored according to the COBOL language variable rule, and therefore the intelligent text analysis and reverse analysis algorithm of the COBOL compiling LOG can be realized.

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

step 301, outputting the field attribute information in the compiling log in a format.

Based on the same inventive concept, an embodiment of the present invention further provides a device for acquiring field information of a COBOL language-based data dictionary, as described in the following embodiments. Because the principles of solving the problems of the COBOL-language-based data dictionary field information acquisition device are similar to the COBOL-language-based data dictionary field information acquisition method, implementation of the COBOL-language-based data dictionary field information acquisition device can refer to implementation of the COBOL-language-based data dictionary field information acquisition method, and repeated parts are not described again. As used hereinafter, the term "unit" or "module" may be a combination of software and/or hardware that implements a predetermined function. Although the means described in the embodiments below are preferably implemented in software, an implementation in hardware, or a combination of software and hardware is also possible and contemplated.

Fig. 4 is a schematic structural diagram of an apparatus for acquiring field information of a COBOL language-based data dictionary according to an embodiment of the present invention, as shown in fig. 4, the apparatus includes:

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

a compiling module 402, configured to perform compiling processing on a data dictionary in source code information of a data dictionary to be analyzed, so as to generate a compiling log;

an information extraction module 403, configured to extract field attribute information in the compilation log according to a COBOL language variable rule, where the field attribute information includes: length data, start position data, and end position data of the fields.

Fig. 5 is a schematic structural diagram of performing cleaning processing on a compilation log according to an embodiment of the present invention, and as shown in fig. 5, the apparatus further includes:

and a cleaning module 501, configured to perform cleaning processing on the compiling log.

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

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

and a format output module 601, configured to format and output the field attribute information in the compilation 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 comprises a memory, a processor, a communication interface and a communication bus, wherein a computer program that can be run on the processor is stored in the memory, and the steps of the method of the embodiment are realized when the processor executes the computer program.

The processor may be a Central Processing Unit (CPU). The Processor may also be other general purpose processors, Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components, or a combination thereof.

The memory, which is a non-transitory computer readable storage medium, may be used to store non-transitory software programs, non-transitory computer executable programs, and units, such as the corresponding program units in the above-described method embodiments of the present invention. The processor executes various functional applications of the processor and the processing of the work data by executing the non-transitory software programs, instructions and modules stored in the memory, that is, the method in the above method embodiment is realized.

The memory may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created by the processor, and the like. Further, the memory may include high speed random access memory, and may also include non-transitory memory, such as at least one disk storage device, flash memory device, or other non-transitory solid state storage device. In some embodiments, the memory optionally includes memory located remotely from the processor, and such remote memory may be coupled to the processor via 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 and when executed by the processor perform the method of the above embodiments.

In summary, the data dictionary in the source code information of the data dictionary to be analyzed is compiled to generate the compiling log by obtaining the source code information of the data dictionary to be analyzed, and the field attribute information in the compiling log is extracted according to the COBOL language variable rule, so that the data content can be obtained in the process of developing and testing the product.

In addition, the invention has the following advantages:

1. all data dictionaries can be dynamically processed in batch in parallel, so that tedious manual operation is avoided, and the working efficiency is improved.

2. The compiled LOG can be intelligently analyzed, the offset and the field length of all fields in the LOGs can be directly obtained, the compiled LOGs can be reversely analyzed, and the definition information and the hierarchical relationship of the fields are shown.

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

4. The invention is attached with a resolving log cleaning mechanism of SPOOL to release system resources.

As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention 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 invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams 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 above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.

Claims

1. A method for acquiring field information of a data dictionary based on a COBOL language is characterized by comprising the following steps:

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

2. The method of claim 1, further comprising:

and cleaning the compiling 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 of claim 1, further comprising:

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

6. The apparatus of claim 5, further comprising:

and the clearing module is used for clearing the compiling log.

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

8. The apparatus of 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, wherein the processor implements the method of any one 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.