Using Informix SPL in the etl scenario
Using Informix SPL in the etl scenario
com.toolsverse.etl.driver.informix.InformixDriver
EXTRACT_LOAD
employee
select EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX from employee
employee
employee_spl
true
if {SEX} = 'M' then insert into employee_spl (EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX) values ({EMPNO},{FIRSTNME},{MIDINIT},{LASTNAME},{TEST},'M'); end if;