Re: CCSID problem converting from IFS Doc CCSID 819 retaining scandinavian characters

Hi Robin,

Which version of OS/400 are they on in Sweden?
I have just come back from sorting out some BPCS client/server problems at a
client in Sweden, with CCSID 65535 versus 278, caused by upgrading to V5R2.
I believe that the PC/AS/400 CCSID translation has changed at V4/V5. I think
that the PC to AS/400 part of NLS may have only just been 'fixed' by IBM at
V5. The AS/400 to AS/400 part was working at V4, so that data in a 278 file
would e correctly translated to your screen etc, however I know that FTP and
ODBC for example did not translate correctly in the past, only recognizing
37 (US).
Also which version of CA do you have? Not sure what CPYFRMPCD uses, but
there may be another way to do this....
Let me know more details and I'll have a think,
cheers,

Clare

Clare Holtham
Director, Small Blue Ltd - Archiving for BPCS
Web: www.smallblue.co.uk
IBM Certified AS/400 Systems Professional
E-Mail: Clare.Holtham@btinternet.com
Mobile: +44 (0)7960 665958
----- Original Message -----
From: "Robin Coles" <robin@ringbase.com>
To: <midrange-l@midrange.com>
Sent: Friday, December 13, 2002 5:20 PM
Subject: CCSID problem converting from IFS Doc CCSID 819 retaining
scandinavian characters


> I have a document in QDLS on a machine in Sweden, with a CCSID according
> to WRKLNK of 819.  If I look at the document with codeedit or ultraedit
> on my PC I can see the Scandinavian special characters OK.
>
> I tried copying the file with CPYFRMPCD to a database file on the system
> and the Scandinavian characters were mistranslated into punctuation,
> curly brackets and various other unhelpful characters.  Checking the
> target file showed it to be CCSID 37.
>
> I tried creating a file that was CCSID 278, which I believe is Swedish,
> and 277 which is Danish/Norwegian and using CPYFRMPCD to that but the
> conversion is still mis-translating the special characters.  I'm using
> *DFT for the translate table on CPYFRMPCD.
>
> The default job CCSID is 65535 but changing it to 278 didn't help.
>
> I'm viewing the characters on their system with a CA session set up as
> host code page 278, and I'm seeing what they're seeing.
>
> Trawling through the archives, I got the impression that the conversion
> should be handled automatically if the CCSIDs were set up correctly.  If
> it makes any difference, the machine is set up as character id 697,
> Codepage 278 and CCSID 65535.
>
> Any ideas?
>
> Cheers
> Rob
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>