DB2 Extract and Load using ADMIN_CMD stored procedure
DB2 Extract and Load using ADMIN_CMD stored procedure
com.toolsverse.etl.driver.db2.Db2Driver
EXTRACT_LOAD
drop_staging_table
dest
com.toolsverse.etl.core.task.common.SqlTask
DROP TABLE employee_stage;
create_staging_table
dest
com.toolsverse.etl.core.task.common.SqlTask
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 DATE, JOB CHAR(8) );
extract
source
com.toolsverse.etl.core.task.common.SqlTask
CALL SYSPROC.ADMIN_CMD ('EXPORT to {DATA_FOLDER}emp.txt OF DEL MESSAGES ON SERVER select EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,PHONENO,HIREDATE,JOB from employee');
load
dest
com.toolsverse.etl.core.task.common.SqlTask
CALL SYSPROC.ADMIN_CMD ('IMPORT from {DATA_FOLDER}emp.txt OF DEL MESSAGES ON SERVER insert into employee_stage');
employee_table
true