Create SPL function and use it in the etl scenario. Use Informix global variable

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Create SPL function and use it in the etl scenario. Use Informix global variable</name>
     <script>spl_function</script>
     <driver>com.toolsverse.etl.driver.informix.InformixDriver</driver>
     <allow>EXTRACT_LOAD</allow>
     <onsave action="save"/>
     <sources>
          <source>
               <name>employee</name>
               <extract>
                    <sql>select EMPNO,FIRSTNME,MIDINIT,LASTNAME,BIRTHDATE,SEX from employee</sql>
               </extract>
          </source>
     </sources>
     <destinations>
          <destination type="function">
               <name>to_value</name>
               <load>
                    <sql>
                       CREATE FUNCTION to_value(v_value int) RETURNING CHAR(6)
                           RETURN cast(v_value as char(6));
                       END FUNCTION;
                   </sql>
               </load>
          </destination>
          <destination>
               <name>employee</name>
               <tablename>employee_function</tablename>
               <metadata>true</metadata>
               <load>
                    <variables>
                             
                         <VAL declare="DEFINE GLOBAL" type="int default 0" sql="let {VAL} = {VAL} + 1;" include="false" />
                         <EMPNO sql="let {EMPNO} = to_value({VAL});" />
                    </variables>
               </load>
          </destination>
     </destinations>
</scenario>