Patent ID: 6698010
Filing Date: 2004-02-24
Classification: G06F

Abstract:
A program generation system for generating a data processing program which searches, updates, and deletes data, which comprises:specifications input means for inputting specifications including program name, input table item definition, select item definition, output table item definition, output table processing definition, select condition definition, and program customize information; a program skeleton customize information obtaining means for taking out said program name and said program customize information from said specifications outputted from said specifications input means; a cursor definition information obtaining means for taking out said input table item definition, said select item definition, and said select condition definition from said specifications outputted from said specifications input means; an output item processing information obtaining means for taking out said output table item definition and said output table processing definition from said specifications outputted from said specifications input means; a cursor definition statement generating means for generating a cursor definition statement on the basis of the output from said cursor definition information obtaining means; a work variable definition statement generating means for generating a work variable definition statement concerning output tables belonging to the processing type â€œinsertâ€  among said output table item definition obtained by said output item processing information obtaining means; an output processing statement generating means for generating on the basis of said output table item definition and said output table processing definition; an output processing statement including a processing condition statement, an item calculation statement, and an insert statement in the case of the processing type â€œinsertâ€ , an output processing statement including a processing condition statement and an update statement in the case of the processing type â€œupdateâ€ , and an output processing statement including a processing condition statement and a delete statement in the case of the processing type â€œdeleteâ€ ; and a program combining means for completing and outputting said data processing program by inserting said program name, said program customize information, said cursor definition statement, said work variable definition statement, and said output processing statement, into a program skeleton which includes a fixed program portion regardless of the content of said specifications and a changeable program portion depending upon said specifications.