By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,279 Members | 1,670 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,279 IT Pros & Developers. It's quick & easy.

Sorting UNICODE as EBCDIC

P: n/a
Hi all,

I'm trying to sort an alphanumerical column as EBCDIC.
Reading on Internet I've found two things:

a) Use CAST(column as CHAR(nn) CCSID EBCDIC).

This gives me the following error:

Message: An unexpected token "EBCDIC" was found following "c AS
CHAR(255) CCSID". Expected tokens may include: "ASCII".

b) Read the casts available in the SYSIBM.SYSSTRINGS table.

I don't have this sysTable neither SYSPARMS!!

Theres anything I can do about it?
Cheers

Oct 4 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Sa****************@gmail.com wrote:
Hi all,

I'm trying to sort an alphanumerical column as EBCDIC.
Reading on Internet I've found two things:
I think there is aosmeconfusion here.
EBCDIC (as far as I know) is an encoding, just like UTF-8 or ASCII.
Sorting is a collation and is orthogonal to the encoding.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Oct 4 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.