RE: Downloading data from AS/400

["Whitaker, Ben" <WhitakB@xxxxxxxxxxxxxxx>]

When we see this problem, we are able to fix it by setting the translation
settings in the DSN.  In the DSN configuration, there is a "Translation" tab
and a setting called "Convert Binary Data (CCSID 65535) to text" or
something similar.  By setting this to convert the data, we have solved the
problem.

The same thing shows when using the Client Access add-in to Excel, and there
is an option in the "properties" to do the conversion.

Ben Whitaker
Project Leader
Mohawk Paper Mills, Inc.
465 Saratoga St
Cohoes, NY 12047
518.233.6210
whitakb@xxxxxxxxxxxxxxx 


-----Original Message-----
From: Andreas.KOPP@xxxxxxxxxxxxxxxx
[mailto:Andreas.KOPP@xxxxxxxxxxxxxxxx]
Sent: Wednesday, March 05, 2003 4:28 AM
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.