Re: Downloading data from AS/400

[<a-mckeown@xxxxxxxxxx>]

Your problem sounds like a combination of two things.  1) The CCSID of the 
fields in the file and two the version of client access and Netsoft.

If the CCSID of the fields is 65535 then you can get peculiar results during 
data transfer.   If the Client Access Version on the PC is V3R2 then data 
transfer can correctly occur.  However if you are running a newer version, say 
Client Access Express V5R1 then you need a translation DLL which IBM doesn't 
provide with Client Access Express or you set the CCSID to 37 (for US English 
CCSID).   You set the CCSID for the character fields in the DDS for the file 
via a keyword (CCSID) on each character field.

Hope this helps.

Andrew McKeown
> 
> From: Andreas.KOPP@xxxxxxxxxxxxxxxx
> Date: 2003/03/05 Wed AM 09:28:21 GMT
> To: bpcs-l@xxxxxxxxxxxx
> Subject: Downloading data from AS/400
> 
> 
> 
> 
> 
> Dear all
> 
> we're running Queries in BPCS on the AS400, create output files and want to
> download them to a PC.
> This download is done either with the 'IBM AS400 Client Access' or with
> NetSoft's 'NS/Transfer'.
> 
> Sometimes in the queries we manipulate data such as converting and
> concetenating them e.g. the customer order status flags in file ECL
> 
> example:
> STATUS        digits(ECL.CLSTS1) !! digits(ECL.CLSTS2) !!
> digits(ECL.CLSTS3) !! digits(ECL.CLSTS4) !! digits(ECL.CLSTS5)
> 
> the output is a string like '00001'
> 
> Downloading this string the result in Excel or a text file is 'F0F0F0F0F1'
> 
> We found that this problem apears in on some PCs and on some PCs not.
> 
> 
> 
> I'd be very happy if anyone has a simple solution
> 
> 
> Best Regards
> Andreas
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
> 
>