Provided is a method, system, and program for maintaining workflow related
information. At least one table is provided in a database storing workflow related
data. A plurality of methods are provided, wherein each method specifies an operation
to perform on the workflow related data in the at least one table, and wherein
each method is associated with one stored procedure call. One stored procedure
is provided in the database for each stored procedure call and corresponding method,
wherein the stored procedure includes a plurality of database statements to perform
the method operation. One stored procedure is executed in the database to perform
the corresponding method operation on workflow related data in one table.
