upgrade-02-021-to-02-022.sql 451 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_RDS_SYNC_UP
  6. AFTER UPDATE OF RENDER_SIZE ON MOB_RENDERS
  7. REFERENCING NEW AS pre
  8. FOR EACH ROW MODE DB2SQL
  9. UPDATE MOB_USER_RENDER SET LAST_VIEWED = CURRENT_TIMESTAMP
  10. WHERE RENDER_ID = pre.RENDER_ID
  11. /