Informix Extract and Load using DbAccess

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Informix Extract and Load using DbAccess</name>
     <script>informix_extract_load</script>
     <driver>com.toolsverse.etl.driver.informix.InformixDriver</driver>
     <allow>EXTRACT_LOAD</allow>
     <tasks>
          
          <task>
               <name>drop_staging_table</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>

<sql>
                   DROP TABLE employee_stage;
               </sql>
               <onexception action="ignore"/>               
          </task>

<task>
               <name>create_staging_table</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                   create TABLE employee_stage
                   (
                     EMPNO	CHAR(6)	not null,
                     FIRSTNME	VARCHAR(12)	not null,
                     MIDINIT	CHAR(1),
                     LASTNAME	VARCHAR(15)	not null,
                     WORKDEPT	CHAR(3),	
                     PHONENO	CHAR(4),	
                     HIREDATE	datetime year to second,	
                     JOB	CHAR(8)	
                   );
               </sql>
          </task>

<task>
               <name>extract</name>
               <connection>source</connection>
               <class>com.toolsverse.etl.core.task.informix.InformixExtractTask</class>
               <driver>com.toolsverse.etl.driver.informix.InformixDriver</driver>
               <sql>select EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,PHONENO,HIREDATE,JOB from employee</sql>
               <variables>
                   <DATA_FILENAME value="{DATA_FOLDER}emp.dat" />
                   <DELIMETER value=";" />
               </variables>
          </task>
          
           
          <task>
               <name>load</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.informix.InformixLoadTask</class>
               <driver>com.toolsverse.etl.driver.informix.InformixDriver</driver>
               <sql>employee_stage</sql>
               <variables>
                   <DATA_FILENAME value="{DATA_FOLDER}emp.dat" />
                   <DELIMETER value=";" />
               </variables>
          </task>
          
          
     </tasks>
     
     <destinations>
          <destination>
               <name>employee_table</name>
               <metadata>true</metadata>
               <cursor table="employee_stage" onfinish="drop" />
          </destination>
     </destinations>
</scenario>