Using SQL/PL in the etl scenario
Using SQL/PL in the etl scenario
com.toolsverse.etl.driver.db2.Db2Driver
EXTRACT_LOAD
employee
select EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX from employee
employee
employee_sqlpl
true
if {SEX} = 'M' then insert into employee_sqlpl (EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX) values ({EMPNO},{FIRSTNME},{MIDINIT},{LASTNAME},{TEST},'M'); end if;