Db2 merge, update, delete

<?xml version="1.0" encoding="UTF-8"?>

<scenario>
     <name>DB2 merge, update, delete</name>
     <script>db2_merge_data</script>
     <allow>EXTRACT_LOAD</allow>
     <driver>com.toolsverse.etl.driver.db2.Db2Driver</driver>
     <sources>
          <source>
               <name>employee</name>
               <extract>
                    <sql>select * from employee</sql>
               </extract>
          </source>
     </sources>
     <destinations>
          <destination>
               <name>employee_upsert</name>
               <source>employee</source>
               <metadata>yes</metadata>
          </destination>

<destination>
               <name>delete</name>
               <tablename>employee_upsert</tablename>
               <source>employee</source>
               <load action="delete" key="EMPNO"> 
                   <variables>
                       <SEX />
                   </variables>
                   <condition>{SEX} = 'M'</condition>
               </load>
          </destination>

<destination>
               <name>update</name>
               <tablename>employee_upsert</tablename>
               <source>employee</source>
               <load action="update" key="EMPNO"> 
                   <variables>
                       <SEX sql="set {SEX} = 'U';" />
                   </variables>
               </load>
          </destination>

<destination>
               <name>merge</name>
               <tablename>employee_upsert</tablename>
               <source>employee</source>
               <load action="merge" key="EMPNO" > 
                   <variables>
                       <SEX sql="if {SEX} = 'M' then 
                                     set {SEX} = 'I'; 
                                 else 
                                     set {SEX} = 'U'; 
                                 end if;" />
                   </variables>
               </load>
          </destination>   
          
          
     </destinations>
</scenario>