Not correct. ASCII transfer mode is absolutely about converting character sets.chulett wrote:I don't believe that anything is corrupted here. I get the impression that they just mean an "ascii" versus "binary" ftp transfer which is all about converting line terminators or not, got nothing to do with characterset conversions.
But he isn't seeing "00A", he's seeing "{00". The leading hex value C1 which represents "this digit is zero, but the whole number is positive", and is also an "{" character in EBCDIC, has been converted to an ASCII "{" character, so there's a hex value 7B there instead."00A" is a perfectly valid signed overpunch value, and yes the "A" represents a positive 1 so what that should turn into is "001+" or just "001" as you noted. It all comes down to your lack of proper settings in the stage, you need to find the settings that Phil and I have been mentioning and get them set properly for those fields.
*Update*: So, in summary, transfer your file in BINARY mode, then you should be able to interpret the decimal values as "leading overpunched", either directly in the file stage or in a subsequent Column Export. Any text fields will also still be in EBCDIC, so you need to specify that in those column properties.