Create TSQL function and use it in the etl scenario. Use Sybase app_context
Create TSQL function and use it in the etl scenario. Use Sybase app_context
com.toolsverse.etl.driver.sqlserver.SybaseDriver
EXTRACT_LOAD
employee
select EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX from employee
to_value
to_value
create function to_value(@v_value int) RETURNS CHAR(6) AS BEGIN return CAST(@v_value as char(6)) END
init_global_var
select @v_dummy = set_appcontext('t_function','val','0')
employee
employee_function
true