Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
CREATE TRIGGER name BEFORE UPDATE ON table REFERENCING OLD AS OLDVAL NEW AS NEWVAL FOR EACH ROW MODE DB2SQL when (OLDVAL.flag != NEWVAL.flag ) UPDATE other_table SET (FEADAT,FEATIM) = (CURRENT DATE, SUBSTR(CAST(current time AS CHAR(8)),1,2) || SUBSTR(CAST(current time AS CHAR(8)),4,2) ) WHERE other_table.id =NEWVAL.id ;
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!