-- 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_M_UPI_SYNC_IN 
AFTER INSERT ON MOB_USER_PORTALITEM
REFERENCING NEW AS pre
FOR EACH ROW MODE DB2SQL
	UPDATE MOB_USERS SET LAST_UPDATED = CURRENT_TIMESTAMP
		WHERE USER_ID = pre.USER_ID
/