JPH02208724A - Table format program generating device - Google Patents

Abstract

PURPOSE:To speedily generate a program by processing the program by each partition such as a processing partition, a deciding partition, a calculating partition, etc., and generating the program by a table format, based on this processing contents. CONSTITUTION:As for a parameter which is inputted, for instance, when it is assumed to generate a batch program in a sales physical distribution system, not only a processing partition, a deciding partition and a calculating partition but also a stock updating partition, a transaction partition, a pricing partition, etc., are given. Subsequently, a storage means 12 for storing a data base stores the data base in a magnetic disk data base DB1, based on a processing form, and distributes the respective components among storage areas. After an input means 11 and the storage means 12 are developed, the processing is shifted to a program processing means 13, and based on a magnetic disk data base DB2, generation of a program is executed. In such a way, the program can be generated at a high speed.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a tabular program generation device that simplifies program creation in, for example, a batch system of a sales distribution system.

[Conventional technology]

Conventionally, when creating batch programs such as distribution, collation, updating, and aggregation, C0BOL, the highest-grade language for office calculations, was used.
However, the instructions and data descriptions were complex, there were many coding errors, and the program manufacturing cost was high. In addition, although simplified languages have become popular recently, they vary from manufacturer to manufacturer, making standardization difficult.

[Problem to be solved by the invention]

In the conventional program creation method described above, after analyzing a program specification and creating a block flow, a detailed flowchart is created and then coding work is performed.

In addition, this coding work requires mastering the words or symbols of various commands before a single program can be completed, so the quality may vary depending on the proficiency of the person writing the program, and it may take a lot of time. There were drawbacks.

For example, when creating an update program, the contents before and after the update may not be completed completely due to coding mistakes, depending on the creator's skill and the scale of the coding. This was the cause of the delay.

Therefore, the purpose of the present invention is to eliminate the conventional coding work and make it possible to create high-quality programs, and to write specifications exactly as they appear on the tabular screen, thereby eliminating interface errors and speeding up program creation. It is an object of the present invention to provide a tabular program generation device that can significantly reduce manufacturing man-hours compared to conventional ones.

[Means to solve the problem]

The configuration of the tabular program generation device of the present invention includes a means for inputting the processing format and parameters of the program, a storage means for storing the components of the program and having a database storage area, and a storage means for storing the components of the program from the storage means. and an output means that generates a program in tabular form based on the processing contents of the program processing means. It is characterized by being

〔Example〕

Next, the present invention will be explained with reference to the drawings.

FIG. 1 is a functional block diagram of an embodiment of the present invention,
11 is an input means, 12 is a storage means, 13 is a program processing means, and 14 is an output means.

The input means 11 selects the program processing mode, for example, distribution, collation, updating, aggregation, generation, etc., using the keyboard KB, display DP, etc. (see FIG. 2).

The processing pattern of the program is determined by selecting these forms.

Next, enter the parameters. The parameters to enter are
It depends on the system you are creating, but for example, assuming you are creating a batch program for a sales distribution system,
In addition to processing categories, judgment categories, and calculation categories, provide inventory update categories, transaction categories, price person categories, etc. At this time, database parameters (customer mask, product mask, inventory mask, etc.)
Also input.

Next, as shown in FIG. 3, the storage means 12 for storing the database stores the database in the magnetic disk database DBI based on the above-described processing format, and allocates each component to a storage area.

After the input means 11 and storage means 12 are developed, the process moves to the program processing means 13, where a program is generated based on the magnetic disk database DB2. In this generation, program patterns for various cases are created using tabular input means.

Finally, the output means 14 outputs the original program to various media (magnetic disk DK, magnetic tape MT, 10ppy disk FD, printer LP, etc.) based on the processing means described above.

Next, the functions of each means will be explained.

Start the program using the input means Niprogram, input the name of the front and back into the blank table, and when the front and back are displayed on the CRT display DP, enter the program processing mode such as distribution, collation, update, aggregation, generation, etc., and enter the parameters by horizontal expansion. Enter. Parameters are set as necessary for processing classification, judgment classification, calculation classification, transaction classification, inventory update classification, and database engineering/
○・Enter record name, record size, etc.

Storage means For storing distribution processing patterns, collation processing patterns, update processing patterns, aggregation processing patterns, generation processing patterns, which are the constituent elements of the Niprogram, and the items and characteristics of files, which are the storage areas of the database DBI. For example, a sales distribution system. In this case, common routine language such as customer mask, product mask, inventory mask, advance master, supplier mask, person in charge mask, priority product mask, sales management mask, log data, table search, item check, etc. It is characterized by storing table names of different languages (COBOL, FORTRAN, etc.).

Program processing means Based on the program processing form and parameter information obtained by two-person means, the database DB2
A data definition section and a data processing section of the program are generated. The generation classification is C0BO, the highest level language for office calculations.
Processing is performed by selecting either L or FORTRAN, the highest level language for scientific computing.

Output means: A source program is generated by the aforementioned program processing means. The generated source program is transferred to a requested medium, such as a magnetic disk DK, by operator intervention.
, magnetic tape MT, floppy disk FD, printer LP, etc.

Next, the operation in this embodiment will be explained.

An example of the source program output pattern shown in FIG. 4 is shown. The program output by the tabular program generator is
Broadly speaking, it can be classified into the following five patterns (A) to (E) in Figure 4.Furthermore, depending on various conditions, dozens of program pattern expansions can be output from these five patterns. Conceivable. FIG. 4(A) is a distribution processing pattern program, which is composed of a program that can distribute log data A1 to records of different log data A3 and log data A4 as constituent elements. Figure 4 (
B) is a matching processing pattern program, which gives a key to the customer mask and product mask based on the log data B1, obtains requested items, and outputs the log data B4. Fourth
Figure (C) is a mask update processing pattern program, which gives a key to the inventory master/supplier mask based on the log data C1 and updates the mask. FIG. 4(D) is an aggregation processing pattern program, which aggregates data of the same code in the log data D1 and outputs it to the log data D3. FIG. 4(E) is a generation processing pattern program, and is an example of a pattern that selects items that meet the conditions from the customer mask, product master, and replacement master and outputs a priority product mask. 9 Tabular program generation device can generate the above program.

In the above description, the creation of a batch program for a sales distribution system has been described as an example, but other similar systems can be used in the same way.

〔Effect of the invention〕

As explained above, the tabular program generation device of the present invention allows for sequential confirmation and correction while looking at the CRT tabular screen, eliminating the conventional coding work and making it possible to create high-quality programs. In addition, by writing the program specifications exactly as they appear on the tabular screen of the tabular program generator, interface errors can be eliminated, program creation can be made faster, and the number of man-hours required for program production can be significantly reduced compared to conventional methods. .

Durham processing means, 14...output means.

Claims (1)

[Claims] A means for inputting the processing form and parameters of a program; a storage means for storing the program components and having a database storage area; and a storage means for receiving the program components from the storage means such as processing classification, judgment classification, calculation classification, etc. What is claimed is: 1. A tabular program generation device comprising: program processing means for performing program processing according to each classification; and output means for generating a program in tabular form based on the processing contents of the program processing means.