Create SQL/PL function and use it in the etl scenario. Use DB2 global variable
Create SQL/PL function and use it in the etl scenario. Use DB2 global variable
com.toolsverse.etl.driver.db2.Db2Driver
EXTRACT_LOAD
create_global_var
dest
com.toolsverse.etl.core.task.common.SqlTask
CREATE VARIABLE vVAL INTEGER default 0;
employee
select EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX from employee
to_value
CREATE OR REPLACE FUNCTION to_value(v_value INT) RETURNS CHAR(6) BEGIN RETURN to_char(v_value); END
employee
employee_function
true
drop_global_var
dest
com.toolsverse.etl.core.task.common.SqlTask
DROP VARIABLE vVAL;