Export data from database table to the fixed lenth text file
<?xml version="1.0" encoding="UTF-8"?> <scenario> <name>Export data from database table to the fixed lenth text file</name> <script>save_as_filex_length_txt</script> <sources> <source> <name>employee_text_fixed_length</name> <onpersist action="save"/> <extract> <sql>select EMPNO,FIRSTNME,LASTNAME,JOB from employee</sql> <writer class="com.toolsverse.etl.connector.text.TextConnector" delimiter=";" fields="6;12;15;8" metadata="false" firstrow="false" filename="{app.root.data}/demo/employee_text_fixed_length.txt" /> </extract> </source> </sources> </scenario>