upgrade-02-021-to-02-022.sql 442 B

1234567891011
  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. UPDATE OF RENDER_SIZE ON MOB_RENDERS
  7. REFERENCING NEW AS pre
  8. FOR EACH ROW
  9. (UPDATE MOB_USER_RENDER SET LAST_VIEWED = CURRENT YEAR TO SECOND
  10. WHERE RENDER_ID = pre.RENDER_ID);