RE: C/A file transfer differences??

When you create your data transfer, click the Details box. You should
see an option labeled "Translate system data to". Mine defaults to
ASCII, which should normally work. Try Other, then the CCSID box
activates, then try 37 for U.S. English.

Have you tried downloading the file directly into Excel using the Client
Access transfer add-in? In the "Customize File Transfer" dialog are
three buttons: data options, format options, and properties. Select
properties, and the first option is Convert CCSID 65535.

Is your system value QCCSID set to something other than 65535? Or
perhaps is there a special reason why this file was created as hex data
(CCSID 65535 means "no translation").

My system QCCSID is set to 37 and all the files I would normally
transfer also show 37.

--Loyd

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Don Cavaiani
Sent: Thursday, November 06, 2008 7:14 AM
To: Midrange Systems Technical Discussion
Subject: RE: C/A file transfer differences??

Loyd,

This is a new transfer - I am doing it the same way I have hundreds of
time before. I do see the 65535 of the file on System i.

Don

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
lgoodbar@xxxxxxxxxxxxxx
Sent: Thursday, November 06, 2008 7:03 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: C/A file transfer differences??

You're seeing the EBCDIC hex representation of the data. The easiest way
to know this is EBCDIC hex x'40' (the repeating "40"s in the segment
below) is a space character (ASCII 32). Is this a new or existing
transfer? Check for CCSID 65535 on the transfer itself, and the CCSID of
the file and field being transferred.

HTH,
Loyd

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Don Cavaiani
Sent: Thursday, November 06, 2008 6:38 AM
To: Midrange Systems Technical Discussion
Subject: C/A file transfer differences??


I'm losin' it!

I've done these C/A file transfers FROM system i5 for years w/o trouble
- to both ASCII and BIFF (Excel) formats!

Now, I do one the very same way, and get this junk when I open it in
Excel:

FTP25
C1404040C2404040C340404040404040404040404040404040

C1404040E5404040C740404040404040404040404040404040

82404040C64040408840404040404040404040404040404040


What the heck is going on this time - is it something about the format
of the data in the System i file??


Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063