Re: File Transfer and CCSID

[ywexler@xxxxxxx]

Dave Shaw wrote:
> 
> -----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
> +---
Another way to transfer files to PC without changing the ccsid is to
copy the file to a folder (Copy to PC Document - CPYTOPCD) and then to
copy this file from the folder to the directory (PC Folder) needed.
+---
| 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
+---