JPH10161914A - Automatic generating method for embedded sql - Google Patents

Abstract

PROBLEM TO BE SOLVED: To efficiently prepare a program for accessing a relational database by automatically generating an embedded SQL to be used for performing access from a program described in COBOL language or C language to the relational data base. SOLUTION: In a data item dictionary 11, data names and attributes more than one corresponding to the programming language are defined for one data item and by linking these data items, data are related. In a table definition file 12, a table name and the most significant item in the data item dictionary 11 are selected. In data definition 13, the table definition to be used is selected according to a template description language described on a template 14. The common description in the template 14 can be described as components 15. A program source containing the embedded SQL is outputted to a program source 17.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to automatic generation of a program, and more particularly, to a program developer having a function capable of creating a part for automatically generating an embedded SQL. The present invention relates to an automatic program generation method that can easily create a program and efficiently create a program that accesses a relational database.

[0002]

2. Description of the Related Art Conventionally, in automatic generation of a program,
When a program for accessing a relational database is to be generated, a target program is generated by synthesizing a skeleton constituting basic logic from a declaration of use of a relational database in a source program, which is described in JP-A-5-61659. There is an automatic generation method of the aggregation processing program.

[0003]

When a relational database is accessed from a program written in COBOL language or C language, embedded SQL can be used. When attempting to create a component for generating an embedded SQL, the following problem occurs. That is, 1. 1. There is no way to acquire and generate column names that make up a table. There is no way to get and generate the embedded variable name that stores the column data.

[0004] 3. There is no way to get and generate embedded variable definitions.

[0005]

SUMMARY OF THE INVENTION In embedded SQL,
A column name constituting the table and an embedded variable name for storing column data are required, and furthermore, an embedded variable definition is required. In the present invention, it is possible to automatically generate an embedded SQL by providing a function of expanding a column name, an embedded variable name and a definition of an embedded variable at the time of generating a program.

[0006]

Embodiments of the present invention will be specifically described below with reference to the drawings. FIG. 1 is a functional configuration diagram showing a configuration of a program development support system according to the present invention. In FIG. 1, 11 is a data item dictionary, 12 is a table definition file, 13 is a program definition, 14 is a template,
Reference numeral 15 denotes a component, 16 denotes a display device, and 17 denotes a generation program source. In the data item dictionary 11, data names and attributes corresponding to one or more programming languages can be defined for one data item, and data can be associated by combining the data item with the data item. In the table definition file 12, the table name and the top item of the data item dictionary 11 can be selected. In the program definition 13, a table definition to be used is selected according to the template description language described in the template 14. The common description in the template can be described as a component 15. The display device 16 displays a screen for selecting a table definition used in the program definition. A program source including an embedded SQL is output to the program source 17.

FIG. 2 shows an example of combining data items in a table composed of fixed-length character type and variable-length character type columns in a data item dictionary. 21, 22, 23, 24, 25 are each one data item, and the upper left, upper right, lower left, and lower right character strings of the rectangle are the column name of the table, the data type of the column of the table, and the data name of the programming language, respectively. And programming language data attributes.

FIG. 3 shows a flow of processing for acquiring a column name.
First, in step 31, a process of extracting the top item specified in the table definition is performed. Next, step 32
, The first data item of the first layer is taken out. Next, in step 33, it is determined whether there is a data item. In step 34, a process of acquiring the column names of the table from the data items is performed. Next, in step 35, a process of taking out the next data item of the hierarchy 1 is performed.

FIG. 4 shows a flow of processing for acquiring an embedded variable name. First, in step 41, a process of extracting the top item specified in the table definition is performed. Next, in step 42, a process of extracting the first data item of the hierarchy 1 is performed. Next, in step 43, it is determined whether there is a data item. In step 44, a process of acquiring the data name of the programming language from the data item is performed. Next, in step 45, a process of taking out the next data item of the hierarchy 1 is performed.

FIG. 5 shows a flow of a process of creating a definition of an embedded variable name. First, in step 501, a process of extracting the top item specified in the table definition is performed. next,
In step 502, a process of extracting the first data item of the hierarchy 1 is performed. Next, in step 503, it is determined whether or not there is a data item of the first tier. In step 504, a process of acquiring the data name and attribute of the programming language of the data item is performed. Next, in step 505, a data definition statement assembling process is performed. Next, step 506
In step 2, the process of extracting the first data item of layer 2 is performed. Next, in step 507, it is determined whether or not there is data of layer 2. In step 508, a process of extracting the data name and the attribute of the programming language of the data item is performed. Next, in step 509, a data definition statement assembling process is performed. Next, in step 510,
The next data item of the hierarchy 2 is fetched. If there is no data of layer 2 in step 507, step 51
In step 1, the next data item of layer 2 is fetched.

[0011]

As described above, the program automatic generation method of the present invention has the following advantages.

1. Access components of the relational database can be created, and program development can be made more efficient and labor-saving.

2. By using the access components of the relational database, the quality of the program to be developed can be improved.

[Brief description of the drawings]

FIG. 1 is a functional configuration diagram illustrating a configuration of a program development support system according to an embodiment of the present invention.

FIG. 2 is a configuration diagram of data in a data item dictionary.

FIG. 3 is a flowchart of column name acquisition.

FIG. 4 is a flowchart of acquiring an embedded variable name.

FIG. 5 is a flowchart of creating an embedded variable definition.

[Explanation of symbols]

11 data item dictionary 12 table definition file 13 program definition 14 program generation 15 template 16 parts 17 program source to be generated 21 top-level data item 22 data item of hierarchy 1 which is connected first to top-level data item 23 top-level data item The data item of the hierarchy 1 which is connected secondly to the data item of the hierarchy 23 The data item of the hierarchy 2 which is secondly connected to the data item of the hierarchy 25 Acquisition process of item 32 Acquisition process of the first data of hierarchy 1 33 Data item existence determination of hierarchy 1 34 Acquisition process of column name of table of data item 35 Acquisition process of next data item of same hierarchy 41 of top item from table definition Acquisition processing 42 Acquisition processing of the first data of layer 1 43 Data item existence determination of layer 1 44 Acquisition process of data name of programming language of data item 45 Acquisition process of next data item of the same hierarchy 501 Acquisition process of top item from table definition 502 Acquisition process of top data item of hierarchy 1 503 Judgment of existence of data item of hierarchy 1 504 Acquisition processing of data name of programming language of data item 505 Assembly processing of data definition statement 506 Acquisition processing of first data item of hierarchy 2 507 Judgment of existence of data item of hierarchy 2 508 Acquisition processing of data name of programming language of data item 509 Data definition statement assembling process 510 Tier 1 next data item acquisition process 511 Tier 2 next data item acquisition process

Continued on the front page (72) Inventor Mitsunori Matsufuji 6-81 Onoecho, Naka-ku, Yokohama-shi, Kanagawa Prefecture Hitachi Software Engineering Co., Ltd.

Claims (1)

[Claims] 1. A function for acquiring a column name constituting a table from a hierarchical data item dictionary, in order to easily create a part for generating an embedded SQL, and a data of a column constituting a table. And a function for acquiring a definition of an embedded variable for storing data of a column constituting a table.