Inline SQL

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Inline SQL</name>
     <description>This scenario demonstrates using of inline sql</description>
     <script>inline_sql</script>
     <driver>auto</driver>
     <allow>EXTRACT_LOAD</allow>
     <sources>
          <source>
               <name>employee</name>
               <extract>
                    <sql>select * from employee</sql>
               </extract>
          </source>

</sources>
     <destinations>
          <destination>
               <name>employee_inline</name>
               <source>employee</source>
               <tablename>employee_inline</tablename>
               <metadata>yes</metadata>
          </destination>

<destination>
               <name>delete</name>
               <load>
                   <sql>
                       delete from employee_inline 
                       where salary >= 90000;
                   </sql>
               </load>
          </destination>

<destination>
               <name>update</name>
               <source>employee</source>
               <load>
                   <variables>
                       <EMPNO />
                   </variables>
                   
                   <sql>
                       update employee_inline 
                       set salary = 70000
                       where EMPNO = {EMPNO};
                   </sql>
               </load>
          </destination>

</destinations>
</scenario>