using merge with ASCII?
Posted: Thu May 14, 2015 2:40 pm
Hi,
I have a project that retrieves a file from the IBMi into my workspace using FTP. I then have a mergefiles task that should take the file and append the data to an existing file on a SQL server (if it already exists) or create a new file. The IBMi file is a "flat" file but contains some hex values within each row. The data I receive on SQL is garbage (unreadable).
This is a re-work of a process on the IBMi that uses FTP directly between the two systems. I think if I can merge the data as ASCII it might work (it does in the original version). How can I change this to ASCII instead of binary? I'd rather not re-write the IBMi file creation process.
Thanks,
Kevin
I have a project that retrieves a file from the IBMi into my workspace using FTP. I then have a mergefiles task that should take the file and append the data to an existing file on a SQL server (if it already exists) or create a new file. The IBMi file is a "flat" file but contains some hex values within each row. The data I receive on SQL is garbage (unreadable).
This is a re-work of a process on the IBMi that uses FTP directly between the two systems. I think if I can merge the data as ASCII it might work (it does in the original version). How can I change this to ASCII instead of binary? I'd rather not re-write the IBMi file creation process.
Thanks,
Kevin