Skip to content

using merge with ASCII?

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
  • monahanks Offline
  • Posts: 41
  • Joined: Wed Mar 30, 2011 10:19 am

using merge with ASCII?

Post by monahanks »

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
  • Support_Jon Offline
  • Support Specialist
  • Posts: 62
  • Joined: Thu Jul 19, 2012 9:15 am
  • Location: Ashland, NE
  • Contact:

Re: using merge with ASCII?

Post by Support_Jon »

Kevin,

Please provide more information.
  • Is the source file in a library or in the IFS?
  • Is the destination file a database file or a stream file?
  • What process are you using to merge the data once it’s on the destination system?
  • Is the file into which you’re merging the data a database or stream file?
  • Are the hex characters always in the same location in the source file?
  • What, exactly, did your original process do?
    • FTP from iSeries physical file to SQL Server data base file?
    • From iSeries physical to SQL Server stream file?
    • From IFS file to SQL Server database?
    • From IFS to SQL Server stream file?
    • Something else that I’ve not mentioned?
With a bit more information, we can better assist you with this process.

Thanks - Jon
  • monahanks Offline
  • Posts: 41
  • Joined: Wed Mar 30, 2011 10:19 am

Re: using merge with ASCII?

Post by monahanks »

Jon,
thanks, Chris emailed me with a solution. Essentially, a two-step process to put the file out as ASCII and then merge it.
Post Reply