Starting a new career can be overwhelming. Becoming certified in your field of expertise is a great start, but where do you go from here? Here are some tips to help you on your career journey.
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 ;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.