The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Dec. 21, 2010
Filed:
Mar. 01, 2006
Andrea C. Martinez, Poughkeepsie, NY (US);
Charles Matula, Poughkeepsie, NY (US);
David H. Starke, Poughkeepsie, NY (US);
Gregory R. E. Wiley, Wappingers Falsl, NY (US);
Andrea C. Martinez, Poughkeepsie, NY (US);
Charles Matula, Poughkeepsie, NY (US);
David H. Starke, Poughkeepsie, NY (US);
Gregory R. E. Wiley, Wappingers Falsl, NY (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
System, method and program product for generating a trigger program that updates an entry in a dependent column in a table in response to a request to update a corresponding entry in a parent column in the table. A trigger program template is provided. The trigger program template includes program steps which indicate a type of update to an entry in an unspecified parent column which triggers an update to a corresponding entry in an unspecified dependent column. The trigger program template also indicates a type of the unspecified dependent column to update upon the update to the entry in the unspecified parent column. The table is automatically scanned to identify one or more dependent columns of the type. In response to identification of the one or more dependent columns of the type, a name of a parent column, corresponding to the one or more dependent columns, is inserted in the trigger program template steps to identify the corresponding parent column as the unspecified parent column and identify the one or more dependent columns as the unspecified dependent columns. Names of the one or more dependent columns comprise the name of the specified parent column and respective suffixes indicating the types of the dependent columns.