I am using CloverETL 2.4.3 and I have tried using the Fixed Data Length Writer and Universal Writer and neither are working as expected.
Fixed Length Data Writer is placing ‘null’ value (^0 in unix) and when I transfer that to windows, Textpad shows that as a big black pipe in each throughout the data.
Universal Data Writer doesn’t write out anything ugly like that null value in the Fixed, but it doesn’t stop at the end of the record at 223 bytes. I have a record delimiter set up on the metadata but it continues to write all the data out on one line. Why is that?
Here is a simple test graph I have been trying to configure to get this to work before putting into my final graph.
<![CDATA[${out.0.EMPI_ID} = ${in.0.memidnum};
${out.0.BEST_ID} = ${in.1.memidnum};
]]>