-- Licensed Materials - Property of IBM
-- BI and PM: Mobile
-- (C) Copyright IBM Corp. 2007, 2012
-- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

CREATE TRIGGER TGR_MOB_RDS_SYNC_UP
UPDATE OF RENDER_SIZE ON MOB_RENDERS
REFERENCING NEW AS pre
FOR EACH ROW
    (UPDATE MOB_USER_RENDER SET LAST_VIEWED = CURRENT YEAR TO SECOND
		WHERE RENDER_ID = pre.RENDER_ID);