pears.personrecordupdated
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL
CREATE PROCEDURE "pears"."personrecordupdated"( /* Application Maintained Function / Procedure - DO NOT EDIT*/ IN "pid" CHAR(20) ) BEGIN UPDATE "person" SET "changedate" = CURRENT TIMESTAMP WHERE "personid" = "pid" END GO COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."personrecordupdated" IS {CREATE PROCEDURE personrecordupdated /* Application Maintained Function / Procedure - DO NOT EDIT*/ (IN pid CHAR(20)) BEGIN UPDATE person SET changedate=CURRENT TIMESTAMP WHERE personid=pid END }