Sorting UNICODE as EBCDIC

[Santiago....@gmail.com]

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

[Serge Rielau]

Santiago....@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/ondemandbusiness/conf2006/