Get new column value using DB2 autoincrement column and sequence and keep referential integrity

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Get new column value using DB2 autoincrement column and sequence and keep referential integrity</name>
     <script>db2_keys</script>
     <allow>EXTRACT_LOAD</allow>
     <driver>com.toolsverse.etl.driver.db2.Db2Driver</driver>
     <tasks>
          <task>
               <name>create_sequence</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                  create sequence SAMPSEQUENCE;
              </sql>
               <onexception action="ignore"/>
          </task>
          <task>
               <name>drop_table</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                  drop table config_property_test;
              </sql>
               <onexception action="ignore"/>
          </task>
          <task>
               <name>create_table</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                 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
                 )      
              </sql>
          </task>
     </tasks>
     <sources>
          <source>
               <name>config_property</name>
               <extract>
                    <sql>select config_property.*, config_property.config_property_num as cfg_prop_num, config_property.config_property_num as CONFIG_NUM 
                         from config_property
                    </sql>
               </extract>
          </source>
          <source>
               <name>config_value</name>
               <extract>
                    <sql>select * from config_value</sql>
               </extract>
          </source>
          <source>
               <name>second_config_value</name>
               <extract>
                    <sql>select config_property_num as con_prop_num, value from config_value</sql>
               </extract>
          </source>
     </sources>
     <destinations>
          <destination>
               <name>config_property_test</name>
               <source>config_property</source>
               <metadata>yes</metadata>
               <load>
                    <variables>
                         
                         <CFG_PROP_NUM function="getAutoInc"/>
                         
                         
                         <CONFIG_PROPERTY_NUM function="getPk" sequence="SAMPSEQUENCE"/>
                         
                         <CONFIG_NUM function="getPk" sql="{CFG_PROP_NUM} + 10000"/>
                    </variables>
               </load>
          </destination>
          <destination>
               <name>CONFIG_VALUE_TEST</name>
               <source>CONFIG_VALUE</source>
               <metadata use="true"/>
               <load>
                    <variables>
                         <CONFIG_PROPERTY_NUM function="getFk"/>
                    </variables>
               </load>
          </destination>
          <destination>
               <name>SECOND_CONFIG_VALUE</name>
               <metadata use="true"/>
               <load>
                    <variables>
                         
                         <CON_PROP_NUM field="CONFIG_NUM" function="getFk"/>
                    </variables>
               </load>
          </destination>
     </destinations>
</scenario>