RE: Sorting characters with accents -- MIDRANGE-L

David,

For your question related to RPG address sorting, I do not believe CCSID would have had any impact. But did you have a chance to test changing your SQL LANGID and SRTSEQ values? If so, did it work?

For your question related to SEU, that is definitely CCSID related. Check the CCSID of the source file and your job CCSID. Make sure neither are 65535. Most likely your job CCSID is as the default is to pick up the job CCSID from the system value QCCSID -- which as we know from yesterday is 65535. You can use CHGJOB CCSID(xxx) to temporarily change your job definition. If you continue to have problems editing the source, then we would need to look at how your display usage is defined to the system. No one should use the variant characters '@', '#', or '$' in variable names if the source code is going to go outside of their company and direct control. Just because RPG allows them doesn't mean they should be used... Interim to changing the system value you could also change the CCSID parameter of your *USRPRF so that your jobs are in a non-65535 environment.

If someone from your system staff is going to look at QCCSID, they may also want to look at the other language related system values. QLANGID clearly being one of them.

Bruce
Bruce Vining Services
507-206-4178

--- On Fri, 1/9/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: Friday, January 9, 2009, 2:30 AM

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.