JP2000322295A - Method and device for programming support for data base stored sub-program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To support description of operation scripts of data base objects conforming to syntax rules of a stored sub-program. SOLUTION: A data base object browser 3, which has classifications of data base objects such as a table, a view, a column, and stored procedures as attributes for individual objects and displays a list of names of individual objects, and a stored sub-program editor 2 which displays the source code of a stored sub-program in a flow chart and classifies it to syntax classifications such as argument definition, variable definition, a control statement, and a processing statement and has them as attributes are prepared, and icons of data base objects are dragged and dropped from the data base object browser to the stored sub-program editor to display a source code description support picture according to the condition of variable declaration, cursor declaration, an SQL statement, or the like.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a programming support method and apparatus for a database stored subprogram stored in a database system.
The present invention relates to a method and an apparatus for editing a stored subprogram suitable for supporting the description of a processing code for a database object.

[0002]

2. Description of the Related Art Conventionally, a system shown in FIG. 6 is known as a system for editing a stored subprogram in a database of this type. Referring to FIG.
The hard disk 510 accessible from
S520 (database management system) is recorded, and the computer 500 performs various record operations such as updating, deleting, and searching on the records in the data file 531 by executing the DBMS 520.

[0003] More specifically, a user enters an SQL (Structured Query) program through a database conversation program 210.
Language) When a processing request is input by a statement, etc., the DBM
S520 executes the corresponding record operation. Also, D
It is also possible to perform the above-described record operation on the record in the data file 531 from a program or the like external to the BMS 520, and further, the record operation is stored in the DBMS management area 530 in advance as a stored subprogram 532 in a script format. It can be created and registered inside. Thus, when a stored subprogram registered in the DBMS 520 is called from an external program or the like, the DBMS 520 executes the processing code of the stored subprogram.

The DBMS of the stored subprogram 532
Registration in the management area 530 is performed by sending a command (CR) to the DBMS 520 via the database conversation program 210.
EATE procedure statement). This database conversation program is a so-called command interpreter type, and the corresponding command and the source program of the stored subprogram may be input at a predetermined input prompt, or the command and the stored subprogram may be input in advance using a text editor or the like. It is also possible to create a text file describing the source program and then read and register this text file.

[0005]

However, in the conventional method of editing a stored subprogram described above,
In describing the source code of the stored subprogram, the description of the source code for operating the database object must be entered correctly without errors regarding the description of database object attributes such as the names and data types of tables and table columns. Is required. Therefore, there is a description error or a typing error, and the editing work efficiency is low, and the work is troublesome. SUMMARY OF THE INVENTION The present invention has been made in view of the above circumstances. In editing parameter declarations, cursor declarations, variable declarations, and database processing codes for database objects, information on objects in a database is transmitted to a DBMS via a database object browser. And display it, and perform the actual editing work by using the display contents, thereby improving the editing work efficiency. In addition, the program source registered in the DBM is analyzed and the entire program source is displayed as a flowchart. It is an object of the present invention to provide a programming support method and apparatus for a database stored subprogram which improves operability for editing by handling.

[0006]

According to a first aspect of the present invention, there is provided a programming support method for a database stored subprogram, which operates a record in a certain database using a predetermined program description language. In a programming support system for a database stored subprogram for editing a stored subprogram of a management system (DBMS), when referring to the database object according to the syntax type of the stored subprogram, the database is transmitted from the DBMS via a database object browser. It is characterized by acquiring and displaying information about a database object inside, and prompting an editing operation of a stored subprogram by referring to the displayed contents. According to a second aspect of the present invention, there is provided the programming support method for a database stored subprogram, wherein the stored subprogram source registered in the DBMS is extracted and the extracted stored program source is analyzed. By logically dividing an argument declaration section and a processing block unit, and further logically dividing the processing block into a variable declaration section and a processing body unit, at least a part of the stored program source is formed as a flow chart of a hierarchical structure. It is characterized by prompting a handling editing operation.

According to a third aspect of the present invention, there is provided a method for supporting programming of a database stored subprogram, the method comprising the steps of: Is logically divided into an argument declaration unit and a processing block unit, and further, the processing block is logically divided into a variable declaration unit and a processing description unit,
In a stored subprogram editing device that treats at least a part of the program source as a flow chart of a hierarchical structure, a database object browser that holds information on names and attributes of respective database objects stored in a database and displays the information in a list. Select an arbitrary database object via, drag and drop, and display the appropriate source code description support screen according to the situation by combining the attribute of the dropped database object and the position on the flow chart And prompting for edit input.

According to a fourth aspect of the present invention, there is provided a programming support system for a stored subprogram for supporting a description of programming in a database object conforming to a syntax rule of a stored subprogram, wherein A database object browser that has an object type as an attribute for each object and displays the name of each object in a list, and displays the stored subprogram source in a flowchart, classifies the stored subprogram into syntax types, and assigns each as an attribute. The attribute icon of an arbitrary database object from the database object browser to an attribute icon of an arbitrary syntax type.
A storage subprogram editing device for displaying a source code description support screen corresponding to the situation and prompting an edit input by dropping. The programming support device for a database stored subprogram according to claim 5 is the device according to claim 4, wherein the stored subprogram editing device converts a source code of the stored subprogram into an argument declaration unit and a processing block unit. Logically divides the processing block into units of a variable declaration section and a processing body section, and analyzes a flow chart display means for displaying a flow chart, and a stored subprogram structure displayed as a flow chart, and Conversion means for assembling a stored subprogram source code that conforms to the description language syntax rules, and a DB for requesting the stored subprogram source code to be registered in a DBMS managed by the system as a database object
MS registration request means, requesting and extracting the stored subprogram registered in the DBMS from the DBMS, analyzing the extracted stored subprogram, and analyzing the stored subprogram in the argument declaration unit, the variable declaration unit in a processing block unit, and the processing main unit. Stored subprogram analysis means for dividing the program into a flow chart and displaying the flow chart through the flow chart display means using the flow chart, and a variable declaration, a cursor declaration, and an SQL statement item in the argument declaration section or the variable declaration section and the processing body section of the flow chart, respectively. It is characterized by including stored program description support means for assisting source code description. Further, the programming support device for database stored subprogram according to claim 6 is the device according to claim 5, wherein the stored program description support means includes a column object in an argument declaration section or a variable declaration section of the flowchart. Column type declaration auxiliary means for assisting the addition of argument declaration items or variable declaration items of the same data type, cursor declaration auxiliary means for assisting the addition of cursor declaration items in the variable declaration section of the flowchart, and processing of the flowchart A record operation assisting means for assisting the addition of an SQL statement item in the main body, and a call description assisting means for assisting the addition of a call item of the stored subprogram in the processing body of the flowchart are provided.

In the above-described configuration, the present invention provides means for editing a stored subprogram of a database system by operating a record in a predetermined database using a predetermined stored subprogram description language. . Here, the record operation includes not only an update-type record operation such as registration and correction of a record, but also a reference-type record operation such as a search. Of course, a complex record operation such as updating a corresponding record after searching for a desired record may be executed. When writing argument declarations, variable declarations, and processing codes in stored subprograms, database objects such as tables and table columns in the database may be referenced. Therefore, as a preferable example of such a case, the database object browser
The information about the database object in the database is acquired from the database management system and displayed. That is, when editing a stored subprogram, information about an object in a database is stored in a database management system (DBMS).
And display it, so that actual editing work is performed using the display contents. The object in the database may be, for example, a table object, a table column object, or a view object, and is not particularly limited. As a result, the editing work efficiency can be improved, and the operability for editing can be improved by analyzing the program source registered in the DBM and treating the entire program source as a flowchart.

[0010]

FIG. 1 is a block diagram showing an embodiment of the present invention. Specifically, a database management system (DBMS) for registering and managing database objects such as tables, views, and stored subprograms.
1 shows a hardware configuration of a programming support system for a database stored subprogram including the following. As shown in the figure, the programming support system for a database stored subprogram of the present invention includes a stored subprogram editing device (script editor) 2 and a list of database objects that can be used by a user of the stored subprogram editing device 2. It consists of a database object browser 3 to be displayed, and both are mapped on the memory of the computer 100.

[0011] A database stored subprogram stores a source program described according to a predetermined syntax rule in a DBM.
A request is made to S520 to register the data as a database object called a stored subprogram in the database. When a stored subprogram is called from an external program or the like, the DBMS 52
0 executes the stored subprogram registered in response to the call. The database object browser 3 uses the connected DBMS 52
0, a table stored in a database managed by
Names of database objects such as views, table columns, view columns, stored procedures,
Holds and displays attribute information such as data type, data length, and argument information. Further, the user can select the displayed database object and drop it on the stored subprogram editing device 2.

The stored subprogram editing apparatus 2 includes a flow chart display means 21 for displaying the structure of the stored subprogram in a flow chart, and a stored subprogram using a predetermined stored subprogram description language. Means for converting to source code (program conversion means) 22;
Stored subprogram registration means 23 for requesting registration at 0
And a stored subprogram analysis means 24 for requesting and extracting stored subprograms registered in the database from the DBMS 520 and analyzing the retrieved stored subprograms so that they can be displayed in a flow chart, variable declarations, cursor declarations, SQL statements, etc. The description support means 25 assists the description of the source code.

The flow chart display means 21 logically divides the stored subprogram source code into an argument declaration unit and a processing block unit, and further logically divides the processing block into a variable declaration unit and a processing body unit. , As a flowchart. The program conversion means 22 analyzes the flow chart,
Assemble a stored subprogram source code that conforms to a predetermined stored subprogram description language syntax rule. The stored subprogram registration unit 23 that requests the DBMS 520 to register the stored subprogram registers the stored subprogram source code assembled by the program conversion unit 22 in the DBMS management area 530.
Request the DBMS 520 to save. When the user requests editing of any stored subprogram registered in the database, the stored subprogram analysis means 24 sends a retrieval command to the DBMS 520, and stores the requested stored subprogram in the DBM.
It is taken out from the S management area 530, analyzed, logically divided into an argument declaration section, a variable declaration section for each processing block, and a processing main body, and displayed via the flow chart display means 21.

The description support means 25 includes a column type declaration auxiliary means 26, a cursor type declaration auxiliary means 27, a record type declaration auxiliary means 30, SELECT (takes out necessary data by a question), INSERT (data is added to a relation),
DELETE (Delete data from relationship), UPDATE
Record operation description assisting means 2 for assisting the creation of an SQL statement for operating a record such as (update related data)
8, and a call description assisting means 29 for assisting the description of the call code of the stored subprogram.

The column type declaration assisting means 26 assists in adding an argument declaration item or a variable declaration item having a data type equivalent to that of the column object to the argument declaration portion or the variable declaration portion of the flowchart. In addition, the cursor type declaration auxiliary means 27
Assists in adding a cursor declaration item to the variable declaration section of the flowchart. Further, the record operation description assisting means 28 assists the addition of an SQL statement item to the processing body of the flowchart. And
The call description assisting means 29 assists in adding a stored subprogram call item to the processing body of the flowchart.
In FIG. 1, reference numeral 510 denotes a hard disk, which is a DBMS.
In the management area 530, a stored subprogram 532 and a data file 531 are mapped and stored.
In addition, the DBMS 520 is connected to the computer 500 if necessary.
The storage subprogram is mapped on the main storage device 505, and fetches or registers the stored subprogram with the computer 100 while performing data transfer with the hard disk 510.

FIG. 2 is a block diagram showing details of the database object browser 3 shown in FIG. The database object browser 3 is the connected DBM
The attribute information including the names, data types, data lengths, and argument information of the database objects such as tables, views, table columns, view columns, and stored procedures stored in the database managed by S520 is stored in the memory of the computer 100. The object information is stored in the allocated object information storage unit 31, and the name of each database object is displayed on the display device. For example,
Regarding the column object “column 1-1”, attribute information having an object type of “column”, a data type and a data length of “character string (30)” is stored in the object information storage unit 31. When the user selects the column object “column 1-1” indicating the column of the table 1 from the display device of the database object browser 3 and drops it on the flow chart display means 21 of the stored subprogram editing device 2, the column object “column 1-1” The attribute information of “1-1” is passed to the stored subprogram editing device 2.

FIG. 3 is a flowchart showing a procedure for editing the stored subprogram 532 by using the description support means 25. The operation of the description support means 25 will be described with reference to the flowchart. First, the name of the stored subprogram, the data type of the return value, and the like are set at predetermined positions in the flowchart. Next, select a column object from the database object browser 3 and drag and drop it into the argument declaration section (step A).
Then, the processing by the column type declaration auxiliary means 26 is executed (step A3), and an argument declaration item having the same type as the dropped column and having a unique name is added to the end of the argument declaration section. (Step A13). Similarly,
Drop a column object from the database object browser 3 into the variable declaration section (steps A4 and A5)
Then, processing by the column type declaration auxiliary means 26 is executed (step A3), and a variable declaration item of the column type or the same type as the column is added to the end of the argument declaration section (step A1).
3). Drop tables and views from the database object browser 3 into the local variable declaration section (step A
6) Then, the stored subprogram editing device 2 asks the user whether to declare a record type variable declaration or a cursor declaration, and when the record type variable declaration is selected, the record type declaration auxiliary means 30 is executed and the cursor Is selected, the processing by the cursor type declaration auxiliary means 27 is executed (step A7), and a variable declaration item of a cursor or record type is added to the end of the argument declaration section (step A13). Even if a database object other than a table, a view, and a column is dropped on the variable declaration section of the flow chart display means 21 of the stored subprogram editing device 2, the description support means 25 does not operate.

When table objects and view objects are dropped (steps A8 and A9) from the database object browser 3 to the processing main body, retrieval, insertion, update, deletion,
The process is executed by the record operation description assisting unit 28 for assisting the description of the SQL statement for performing the process such as the lock (step A10). Record operation description auxiliary means 2
Numeral 8 requests the user to input predetermined information necessary for record operation, generates an SQL sentence using the input value or expression, and adds an item to the end of the processing body of the flow chart display means 21 ( Step A13). Similarly, when the stored subprogram object is dropped from the database object browser 3 to the processing body (step A11), the call description assisting means 29 for generating an SQL statement for calling the stored program is executed (step A12). ). The call description assisting means 29
If the dropped stored subprogram requires an argument, request the user to enter a value or expression to be given to the argument, generate a stored subprogram call code using the entered value or expression, and display a flow chart Means 21
Add an item to the end of the processing body of (Step A1)
3).

Next, the operation of the embodiment of the present invention will be described using a specific example. FIG. 4 is a diagram showing the flow of data operation between the database object browser 3 and the flow chart display means 21 of the stored subprogram editing device 2 and the structure of the stored program. Now, it is assumed that a new stored subprogram having the structure shown in FIG. 4 is newly created and registered. Argument declaration arg1, Argument declaration arg2
Are the data field col-1 and the data field coll of table # 1 in the database, respectively.
-2, which is information for updating, and is required to match the data type of the corresponding field of the database table. When the column object of the data field col-1 is dragged from the database object browser 3 and dropped on the argument declaration section of the flow chart display means 21 (operation 41), the column type is set via the steps A1 and A2 shown in the flowchart of FIG. The processing by the declaration assisting means 26 is executed. Initially, the column type declaration auxiliary means 26 automatically assigns a unique name to the name of the argument, but the user can edit and change it. When the execution of the column type declaration auxiliary means 26 is completed, an argument item arg1 having the same data type as the data field is added to the lower hierarchy of the argument declaration part of the flow chart display means 21. In the same procedure (operation 42), the argument item arg2 is also declared.

The variable var1 is used to temporarily store the value of the data field col-3 of the table 1 in the database, and needs to match the data type and data length of the data field col-3. And When the corresponding data field coll-3 object is dragged from the database object browser 3 and dropped on the variable section of the flow chart display means 21 (operation 43), the processing is performed according to steps A1, A4, and A5 shown in the flowchart of FIG. , The column type declaration auxiliary means 26 is executed. Initially, the column type declaration auxiliary means 26 automatically assigns a unique name to the variable name, but the user can edit and change it. When the execution of the column type declaration auxiliary means 26 is completed, a variable item var1 having the same data type and data length as the column is added to the lower hierarchy of the variable declaration part of the flow chart display means 21. if,
If there is a column type in which the column name can be declared as a data type in the stored subprogram description language of the target DBMS 520, a variable item of the column data type is added to a lower hierarchy of the variable declaration section of the flow chart display means 21. .

The variable var2 is for temporarily storing the record of the table # 2 in the database, and is a record type variable if the record type exists in the cursor or the stored subprogram description language of the DBMS 520. Drag the corresponding table # 2 object from the database object browser 3 and drop it on the variable declaration section of the flowchart display means 21 (operation 44).
Steps A1, A4, shown in the flowchart of FIG.
The target DBMS 52 through the processing according to A5 and A6
If the stored subprogram description language of 0 can define a record type variable, first ask the user whether to define a cursor or a record type variable, and select the record type variable declaration process. The processing by the record type variable declaration auxiliary means (not shown) is executed. If the cursor type is selected for the inquiry or the stored subprogram description language cannot define the record type, the processing by the cursor type declaration auxiliary means 27 is executed. In the cursor type declaration auxiliary means 27,
Initially, a unique name is automatically assigned to the name of the cursor or record-type variable, but can be edited and changed by the user. When the execution of each description support unit 25 is completed, the cursor or the item of the record type variable is added to the lower hierarchy of the variable declaration part of the flow chart display unit 21.

Similarly, when table # 2 is selected on the database object browser 3 and dropped on the processing body of the flow chart display means 21 (operation 45), steps A1, A4, A4 and A8 shown in the flowchart of FIG. , A
9, the record operation description assisting means 28 is executed. The record operation description assisting unit 28 requests the user to input information relating to any one of the SQL commands of the search process, the record insertion process, the record update process, and the record deletion process to the table # 2. Is completed, the SQL command item is added to the lower hierarchy of the processing main body of the flow chart display means 21.
The contents of the SQL command statement can be changed later.

Similarly, when the object of the stored subprogram stprogram1 is selected on the database object browser 3 and dropped on the processing main body of the flow chart display means 21 (operation 46), steps A1, A4 and A4 shown in the flowchart of FIG. Through the processing according to A8, A9, and A11, the processing by the stored subprogram call description auxiliary means 29 is executed. The call description assisting means 29 provides the user with a stored subprogram stp.
When the user requests an argument value for program1 and completes the input, the SQL command item is displayed in the flow chart display means 21.
Is added to the lower hierarchy of the processing main body. The contents of the SQL command statement can be changed later.

The user adds and edits other program items such as control syntax and expression by a predetermined procedure, finishes the description of the stored subprogram, and stores the program in the stored subprogram editing apparatus 2 and in the database management system management area 530. When the registration is requested, the stored subprogram editing device 2 executes the converting means 22 for converting the flowchart into the stored subprogram, and converts the flowchart into the source code in the stored subprogram description language of the DBMS 520,
Executing the stored program registration means 23 to execute the DBMS
A registration processing request to 520 is made.

FIG. 5 is a flowchart cited for explaining the operation of another stored subprogram editing method by exemplifying a specific stored subprogram. Hereinafter, the operation will be described with reference to this flowchart. First, when the user requests the editing of the stored subprogram 532 existing in the database management area 530, the stored subprogram editing device 2 requests the DBMS 520 to extract the stored subprogram 532 via the analysis unit 24, and extracts the stored subprogram 532. (Step S5
1). Then, the retrieved stored subprogram 53
2 is analyzed so that it can be displayed in a flow chart, and the flow chart display unit 2
1 is displayed with the analysis result (step S52).

The procedure for displaying the stored subprogram source code illustrated in FIG. 5 in the state of the flowchart display means 21 shown in FIG. 4 is as follows. First, the character string next to the delimiter (parentheses or spaces) after the stored subprogram name at the beginning of the stored subprogram source code is interpreted as an argument declaration, and for each argument declaration, the argument declaration of the flowchart display means 21 is made. It is displayed as an item in the lower hierarchy of the section. Next, a keyword indicating a variable declaration such as "AS DECLARE" is searched for, and a character string up to a keyword "BEGIN" indicating the start of the processing body is interpreted as a variable declaration, and each variable separated by a semicolon or an equivalent delimiter is searched for. For each declaration, it is displayed as an item in the lower hierarchy of the variable declaration section of the flowchart display means 21.
Next, the keyword “BEGI” indicating the start of the processing main unit
N, the keyword “EN” indicating the end of the processing main unit
The character string up to D "is interpreted as a description of the processing main unit, and for each processing description delimited by a semicolon or an equivalent delimiter, it is displayed as an item of a lower hierarchy of the processing main unit of the flow chart display means 21.

In the following, the user edits the stored subprogram source by using the various description assisting means 25 by the means described above (step S53).
The stored subprogram source using the predetermined stored subprogram description language of the DBMS 520 is assembled through the conversion means 24 from the flowchart to the stored subprogram (step S54). Then, the registration request of the stored subprogram 532 to the database management area 530 is again requested to the DBMS 520 via the database registration processing means 23 (step S55).

As described above, according to the present invention, a database object browser having a type of a database object such as a table, a view, a column, or a stored procedure as an attribute for each object and displaying a list of the names of the objects is provided. A source code of a program is displayed in a flow chart, classified into syntax types such as an argument definition, a variable definition, a control expression, and a processing statement, and a stored subprogram editing device having the attribute as an attribute is prepared. By dragging and dropping the icon of the object to the stored subprogram editing device 2, a source code description support screen corresponding to the situation such as variable declaration, cursor declaration, and SQL statement is displayed, and the source without any description mistakes is displayed. It is intended to support the over-de-description.

According to the present invention, for example, when a table object icon is dragged from the database object browser 3 and dropped on the processing statement icon of the stored subprogram editing apparatus 2, an SQL statement creation support screen is displayed. On the other hand, if the same table object icon is dragged and dropped on the variable declaration icon of the script editor 2, a cursor declaration support screen is displayed. As described above, the combination of the icon on the database object browser 3 and the attribute of the icon on the stored subprogram editing device 2 makes it possible to support the description of an appropriate source code according to the situation, thereby improving the work efficiency. .

[0030]

As described above, the present invention relates to a programming support system for a database stored subprogram which edits a stored subprogram of a DBMS for operating a record in a database using a predetermined program description language. When referencing the database object according to the syntax type of the subprogram, via the database object browser,
Acquiring information about database objects in a database from the DBMS, displaying the acquired information, and prompting an editing operation of a stored subprogram by referring to the display contents; It is possible to reduce the user's key type input in the description of the argument declaration, the variable declaration, and the operation command related to the object, thereby reducing the description mistake. As a result, the editing work efficiency is improved.
Further, the work efficiency can be further improved by expressing the entire program source to be edited in a flow chart.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an embodiment of the present invention.

FIG. 2 is a block diagram showing details of a data object browser shown in FIG. 1;

FIG. 3 is a flowchart showing an operation procedure by the description support means shown in FIG. 1;

FIG. 4 is a diagram cited for explaining the operation of the embodiment of the present invention, showing a structure of a newly created stored subprogram and an outline of operations.

FIG. 5 is a flowchart showing an operation procedure according to another embodiment of the present invention.

FIG. 6 is a block diagram showing a configuration example of a conventional programming support system for a database stored subprogram.

[Explanation of symbols]

2 ... Stored subprogram editing device 3 ... Database object browser 21 ... Flow chart display means 22 ... Program conversion means 23 ... Stored subprogram registration means 24 ... Stored subprogram analysis means 25 ... Description support means 26 ... Column type declaration auxiliary means 27 ... Cursor type declaration auxiliary means 28 ... Record operation description auxiliary means 29 ... Call description auxiliary means 520 ... Database management system program (DBM
S) 530: DBMS management area 532: stored subprogram

Claims (6)

[Claims] 1. A programming support system for a database stored subprogram for editing a stored subprogram of a database management system (DBMS) for operating a record in a database using a predetermined program description language, wherein the syntax of the stored subprogram is When referring to the database object according to the type, the information about the database object in the database is acquired and displayed from the DBMS via the database object browser, and the stored subprogram is edited by referring to the display contents. A programming support method for a database stored subprogram characterized by prompting. 2. Extracting a stored subprogram source registered in the DBMS, analyzing the extracted stored program source, logically dividing it into an argument declaration unit and a processing block unit, and further declaring the processing block as a variable. 2. The database stored subprogram according to claim 1, wherein at least a part of the stored program source is treated as a flow chart of a hierarchical structure to prompt an editing operation by logically dividing the stored program source into units. Programming support method. 3. In a programming support system for a stored subprogram supporting a description of programming in a database object conforming to the syntax rules of the stored subprogram, a stored subprogram source is logically divided into a unit of an argument declaration unit and a processing block. The processing block is logically divided into units of a variable declaration section and a processing description section, and at least a part of the program source is stored in a database in a stored subprogram editing apparatus which handles the flowchart as a hierarchical flow chart. By holding information on the name and attribute of each database object and selecting and dragging and dropping any database object via the database object browser that displays the information, a drop-down A programming support method for a database stored subprogram, comprising displaying an appropriate source code description support screen according to the situation and prompting an edit input based on a combination of the attribute of the database object and the position on the flowchart. 4. A programming support system for a stored subprogram for supporting a description of programming in a database object that conforms to the syntax rules of a stored subprogram, wherein the system has a type of the database object as an attribute of each object, and A database object browser for displaying a list of names, and displaying the stored subprogram source in a flow chart, classifying the stored subprograms into syntax types, each having an attribute, and an attribute icon of an arbitrary database object from the database object browser. By dragging and dropping to the attribute icon of any syntax type, displays a source code description support screen corresponding to the situation and prompts for editing input A programming support system for a database stored subprogram, comprising: a subprogram editing device. 5. The stored subprogram editing apparatus logically divides a source code of the stored subprogram into an argument declaration unit and a processing block unit, and further divides the processing block into a variable declaration unit and a processing body unit. A flow chart display means for logically dividing the stored sub program structure into a flow chart, a code conversion means for analyzing a stored sub program structure displayed in the flow chart, and assembling a stored sub program source code conforming to a predetermined description language syntax rule; DBMS registration request means for requesting registration of a stored subprogram source code as a database object to a DBMS managed by the system, requesting and extracting the DBMS-registered stored subprogram from the DBMS, and analyzing the extracted stored subprogram Argument declaration section, processing block Stored subprogram analysis means which is logically divided into a variable declaration section and a processing body section for each block, and which displays a flow chart by a flow chart through the flow chart display means; an argument declaration section or a variable declaration section of the flow chart; 5. The programming support system for a database stored subprogram according to claim 4, wherein each of the sections includes a stored program description supporting means for assisting a source code description of a variable declaration, a cursor declaration, and an SQL statement item. 6. The column type declaration assisting means for assisting the addition of an argument declaration item or a variable declaration item of the same data type as a column object in an argument declaration portion or a variable declaration portion of the flowchart. A cursor declaration assisting means for assisting addition of a cursor declaration item to a variable declaration part of the flowchart; a record operation assisting means for assisting addition of an SQL statement item to a processing body of the flowchart; and a processing body of the flowchart. 6. The programming support system for a database stored subprogram according to claim 5, further comprising a call description assisting means for assisting the addition of a call item of the stored subprogram.