Using MySql procedural language in the etl scenario

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Using MySql procedural language in the etl scenario </name>
     <description>Using MySql procedural language in the etl scenario </description>
     <script>mysqllang</script>
     <driver name="com.toolsverse.etl.driver.mysql.MySqlDriver"/>
     <allow>EXTRACT_LOAD</allow>
     <onsave action="save"/>
     <sources>
          <source>
               <name>employee</name>
               <extract>
                    <sql>select EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX from employee</sql>
               </extract>
          </source>
     </sources>
     <destinations>
          <destination>
               <name>employee</name>
               <tablename>employee_mysql</tablename>
               <metadata>true</metadata>
               <load>
                    <variables>
                         <EMPNO/>
                         
                         <TEST sql="set {TEST} = SYSDATE();" type="DATE"/>
                         <FIRSTNME/>
                         <MIDINIT/>
                         <LASTNAME/>
                         <SEX/>
                    </variables>
                    <sql>
                       if {SEX} = 'M' then
                           
                           if {EMPNO} = '000230' then
                               set {EMPNO} = {EMPNO}; 
                           end if;  
                       
                           insert into employee_mysql (EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX)
                           values ({EMPNO},{FIRSTNME},{MIDINIT},{LASTNAME},{TEST},'M');
                       end if;
                   </sql>
               </load>
          </destination>
     </destinations>
</scenario>