To automatically generate a data processing program for referring to, updating, and deleting the data of a table of a database, using a cursor definition statement.
A means 101 accepts specifications 1. From the specifications 1, a means 102 takes out program customize information, a means 103 does input table item definition, select item definition and select condition definition, and a means 104 does output table item definition and output table processing definition, respectively. A means 105 generates a cursor definition statement from the information obtained by the means 103, means 106 and 107 generate, from the information obtained by the means 104, a work variable definition statement and an output processing statement depending on the specified processing type (insert, update, delete), respectively. A means 109 generates a program 2 by inserting the program customize information, the cursor definition statement, the work variable definition statement and the output processing statement, into the corresponding inserting positions of a program skeleton 108 which includes the program of a fixed portion regardless of the content of the specifications and an inserting position of a piece of the program corresponding to a portion changeable according to the specifications.
SATO AKIRA
Kawai Nobuaki
Yasuhisa Tanizawa
Next Patent: DOUBLE REFRACTION AMOUNT ESTIMATING DEVICE OF OPTICAL DISK, AND OPTICAL DISK DRIVE