Re: File Transfer and CCSID

[Dave Shaw <dshaw1@xxxxxxxxxxx>]

-----Original Message-----
From: John Earl <johnearl@lns400.com>


>A customer is having difficulty with creating result files from
>query files.  They want to have end users query data to result
>files and then FTP those result files to the PC.  When they do
>this however, all the fields in the files contain the HEX
>representation of the data.(a digit '1' is written as 'F1' etc).
>All the fields in the file are described as alpha.
>
>The cusomer is using MAPICS on a V3R6 box, and the MAPICS file
>uses CCSID 65535.  Therefore the reult PF inherits that 65535
>CCSID.  If I FTP the result file to a V3R7 box, the file is
>written to the V3R7 box with CCSID 500.  I can then FTP  that
>file to the PC and the data is represented correctly,
>
>If I FTP that same file from the V3R7 box back to the V3R6 box,
>the file again inherits CCSID 500 and can be downloaded
>correctly.
>
>So the question is, is there a simple way to enable their
>end-users to use query to create result PF's, and then FTP those
>PF's to the PC.... even when the queried file has CCSID 65535?
>
>Is there an (east)  way to change all files to use a better CCSID
>
>(like 500, or even better 37).  Is this advisable to do to MAPICS
>
>(My guess is no).


John,

How're ya doin'?  Haven't hollered at ya in awhile! :)

Your guess is wrong.  (That was fun! ;)

Seriously, when we put in our RISC box, we found most of our MAPICS files
had 65535.  When we called MAPICS about it, theirs all had 37!  We
determined (after pestering IBM from both sides) that the reason ours had
65535 was because of the particular way that we had upgraded our system from
V2R2 through V2R3 and V3R1 to V3R6.  They suggested that we write a CL
program to do a DSPFD to an outfile (I forget which format, but one that
includes CCSID in the output), then read the outfile and do a CHGPF to CCSID
37.  It worked like a charm.  Try it.

Dave Shaw, General Nutrition, Greenville, SC (just down the road from BMW -
Bubba Makes Wheels :)
MAPICS victim since 1980 (MMAS victim 1978-1981)
The opinions expressed may not be my employer's unless I'm sufficiently
persuasive...


root
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---