Re: Downloading data from AS/400

Thanks to all

now the download with Client Access works properly.

Maybe some of you also use Net Soft's NS Transfer (and only NS Transfer)
and have the same problem.
I found something that should also help Net-Soft-users:

HEX PROBLEM
You may experience character (CHAR) data corruption if you download mixed data 
(CHAR and HEX fields)
over a Direct TCP/IP or Direct IPX/SPX link from your AS/400.
IBMâs AS/400 Database Server makes no distinction between HEX and CHAR 
fields.  HEX fields always have
a CCSID (code page identifier) of 0xFFFF (65535), which indicates no 
translation during file transfer.
The problem arises if you choose CCSID of 65535 for the total file being 
downloaded. In this case, all CHAR
fields are also treated as HEX fields.

There are two current solutions.

1     Enter the following command on your AS/400 to change the CCSID for the 
file to 037 (EBCDIC):
      CHGPF FILE(library/filename) CCSID(37)
2     Add the following Registry entry:
      [HKEY_LOCAL_MACHINE\SOFTWARE\NetSoft\NS/Elite\CurrentVersion\E32TFW] 
"ForceTranslation"=hex:01



Many Thanks
Andreas






<a-mckeown@xxxxxxxxxx>@midrange.com on 05.03.2003 14:16:52

Please respond to "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>

Sent by:    bpcs-l-bounces@xxxxxxxxxxxx


To:    "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
cc:
Subject:    Re: Downloading data from AS/400



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.
>
>

_______________________________________________
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.

The  information  contained  in this e-mail and any attachments is strictly
         confidential  and  may be legally privileged. It is intended
solely for the use of the individual or entity to whom it is addressed. If
         you are not the named  addressee,  you are hereby notified that
it is prohibited and may be unlawful  to disclose, copy, distribute, store,
         copy the information in any medium or usage for another purpose.