upgrade-02-004-to-02-005.sql 431 B

123456789101112
  1. -- Licensed Materials - Property of IBM
  2. -- BI and PM: Mobile
  3. -- (C) Copyright IBM Corp. 2007, 2012
  4. -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  5. CREATE TRIGGER TGR_MOB_UR_SYNC_IN
  6. AFTER INSERT ON MOB_USER_RENDER
  7. REFERENCING NEW AS pre
  8. FOR EACH ROW MODE DB2SQL
  9. UPDATE MOB_USERS SET LAST_UPDATED = CURRENT_TIMESTAMP
  10. WHERE USER_ID = pre.USER_ID
  11. /