Get new column value using Informix serial column and sequence and keep referential integrity
Get new column value using Informix serial column and sequence and keep referential integrity
EXTRACT_LOAD
com.toolsverse.etl.driver.informix.InformixDriver
create_sequence
dest
com.toolsverse.etl.core.task.common.SqlTask
create sequence sq_config_property;
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 INTEGER not null, NAME VARCHAR(255), DESCRIPTION VARCHAR(255), DEFAULT_VALUE LVARCHAR(3000), CFG_PROP_NUM SERIAL NOT NULL, CONFIG_NUM INTEGER 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
yes
second_config_value
yes