Get new column value using DB2 autoincrement column and sequence and keep referential integrity
Get new column value using DB2 autoincrement column and sequence and keep referential integrity
EXTRACT_LOAD
com.toolsverse.etl.driver.db2.Db2Driver
create_sequence
dest
com.toolsverse.etl.core.task.common.SqlTask
create sequence SAMPSEQUENCE;
drop_table
dest
com.toolsverse.etl.core.task.common.SqlTask
drop table config_property_test;
create_table
dest
com.toolsverse.etl.core.task.common.SqlTask
create table config_property_test ( CONFIG_PROPERTY_NUM DECIMAL(18) not null, NAME VARCHAR(255), DESCRIPTION VARCHAR(255), DEFAULT_VALUE VARCHAR(3000), CFG_PROP_NUM INTEGER GENERATED ALWAYS AS IDENTITY, CONFIG_NUM DECIMAL(18) not null )
config_property
select config_property.*, config_property.config_property_num as cfg_prop_num, config_property.config_property_num as CONFIG_NUM from config_property
config_value
select * from config_value
second_config_value
select config_property_num as con_prop_num, value from config_value
config_property_test
config_property
yes
CONFIG_VALUE_TEST
CONFIG_VALUE
SECOND_CONFIG_VALUE