RE: Sorting characters with accents

Thanks for this.

I am a little out of my depth here as we have a team dedicated to maintaining the system and I am not part of that team. I have never had to understand what CCSID is and after a brief search on the net I find I am not a lot wiser but a little more concerned. Particularly when I stumbled upon Character Conversion Errors with Job CCSID 65535 at http://www-912.ibm.com/s_dir/slkbase.NSF/0/9ea41ee0c6099d1e86256caa006e4b59?OpenDocument

My reason for my original post was that a fellow programmer was creating batch loads of mail that should have been sorted by addressee. An RPG program sent the information in XML which was treated by a Java application to create PDF documents from the XML file. How would changing the CCSID have an effect here?

On another note, I have had problems with the sample programs in the xml toolkit. The pointer variables all end with a @. I can compile the source, but if I try and edit one of these lines, the SEU editor refuses to accept this character. Is this also linked to CCSID?



-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Bruce Vining
Envoyé : jeudi 8 janvier 2009 17:19
À : Midrange Systems Technical Discussion
Objet : Re: Sorting characters with accents

I certainly don't disagree that having QCCSID set to 65535 is a problem, but I don't believe you will find it's a problem in this specific case.

National language sorting is controlled primarily through language ID (LANGID) and sort sequence (SRTSEQ). These are both job attributes in addition to system values. And in the case of interactive SQL, also session attributes. Proper CCSID tagging is certainly critical to ensuring character data integrity is maintained, but doesn't directly come into play with sorting preferences.

Bruce
Bruce Vining Services
507-206-4178

--- On Thu, 1/8/09, Vern Hamberg <vhamberg@xxxxxxxxxxx> wrote:

From: Vern Hamberg <vhamberg@xxxxxxxxxxx>
Subject: Re: Sorting characters with accents
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: Thursday, January 8, 2009, 9:12 AM

David

The 65535 is your first problem - it should be changed immediately to the CCSID for your national language version. I almost think that if you changed this, your sort might already be fixed.

Second, Bruce was talking about LANGID - try DSPSYSVAL QLANGID to see what it is.

Vern

David FOXWELL wrote:

Bruce,

That order would be perfect.

But it's not changing anything for me. DSPSYSVAL QCCSID gives 65535.

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx

[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Bruce Vining

Envoyé : jeudi 8 janvier 2009 15:28
À : Midrange Systems Technical Discussion Objet : RE: Sorting
characters with accents

Set your LANGID to FRA (to match I assume your CCSID of 297 given your

codepoints) and sort sequence to *LANGIDUNQ. This will approximate the order you have in your list. I say approximate due to ê collating after é and è in my quick test. You could create your own table to sort in your desired order though (or find a more appropriate LANGID).

Bruce Bruce Vining Services 507-206-4178

--- On Thu, 1/8/09, David FOXWELL <David.FOXWELL@xxxxxxxxx> wrote:

From: David FOXWELL <David.FOXWELL@xxxxxxxxx>
Subject: RE: Sorting characters with accents
To: "Midrange Systems Technical Discussion"

<midrange-l@xxxxxxxxxxxx>

Date: Thursday, January 8, 2009, 8:11 AM

Have I a chance in hell of getting this order : ?

a 81
à 7C
c 83
ç E0
e 85
ê 52
é C0
è D0

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx

[mailto:midrange-l-bounces@xxxxxxxxxxxx]

De la part de Vern Hamberg
Envoyé : jeudi 8 janvier 2009 14:49
À : Midrange Systems Technical Discussion Objet : Re: Sorting
characters

with accents

Here's what I see -

The first sort is done according to the actual hex value of the
character

in AZ

- notice that it is in order by the hex numeric value - numbers come

before letters - the order is 0123456789ABCDEF.

Now the second sort is done according to the character representation
of

the hex value - so letters come before numbers, in the normal EBCDIC order.
Letters before numbers.

In embedded SQL you can set the sort sequence - set option srtseq=*JOB
or

*HEX or *JOB or *JOBRUN or *LANGIDSHR or *LANGIDUNQ - you can even name a sort table.

This is an option you set at the top of the source code and applies to

everything in a single code unit - so if you need both case-sensitive and case-insensitive options, you have to do it with

2 modules - a great case for ILE!!

Eh?
Vern

David FOXWELL wrote:

Hi,

With this request : SELECT AZ , hex( AZ ) FROM az ORDER BY AZ

I'm getting
AZ HEX ( AZ )
ê 52
à 7C
a 81
c 83
e 85
é C0
è D0
ç E0

If I use ORDER BY hex(AZ)
I get
AZ HEX ( AZ )
é C0
è D0
ç E0
ê 52
à 7C
a 81
c 83
e 85

Can anyone tell me how the sorting works?
Thanks

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,

visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a

moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,

visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a

moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,

visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a

moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.