|
Hi Ian, Sounds like your text file is being saved as Unicode (2-bytes per character). With Notepad, try doing a File menu SaveAs and see if the "Save as Unicode" check box is checked. Uncheck it and save it, then do the FTP. hth, Peter Dow Dow Software Services, Inc. 909 425-0194 voice 909 425-0196 fax From: "Ian J. Forsyth" <iforsyth@360GROUP.com> I seem to be getting binary zeroes in the transferred data. I just uploaded a text file into a source file member with the word TEST in it. I merely opened notepad typed TEST, saved the file as TEST.TXT, and did the ftp transfer. Here's what the hex view looks like--field names below. The text apears to start with the srcdta field. 000100000000˙ūT E S T FFFFFFFFFFFFD8E0C0E0E 000100000000FE3050203 S S S R R R C C C S D D E A T Q T A I know I can probably copy to a physical file and do a convert source, but what's really frustrating is that the IBM SQL Server Conversion Article tells you to FTP your sql text file directly into your source file member. Can this kind of transfer be done? _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.