RE: Downloading data from AS/400

["Paul Reed" <PR@xxxxxxxxxxxx>]

Try This:

In Client Access, get to the "Data Transfer from AS/400" pop-up window.

Then, select the pull-down option for File.

Select the option for properties.

In the Conversions tab, there is a check box for "Convert CCSID 65535"

Good luck!

Sincerely,
Paul Reed
Advanced Systems and Products (ASAP)
The Experts in the AS/400 BPCS AS/SET RPG
PR@xxxxxxxxxxxx
877 USE-ASAP
www.BPCSPros.com


-----Original Message-----
From: bpcs-l-bounces+pr=bpcspros.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+pr=bpcspros.com@xxxxxxxxxxxx] On Behalf Of
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.