Trigger in TDM for MySQL


Could you please help me to create Triggers in TDM for MySQL.

  1. I tried creating After Update Trigger in TDM as below, but I am getting error if I execute this in MySQL.

After Update Trigger:


UPDATE customer_wname SET whole_name=CONCAT(NEW.first_name,’ ‘,NEW.last_name,’ ',NEW.middle_name) WHERE;


  1. It would be great if someone shares me the instructions on how to use the “Insert Template” and “Open Template Editor” which is available in Trigger properties–>Under SQL tab.

Thanks !!

if you go into HELP and search for ‘template editor’ this may answer your questions.