Prev: db2cli.ini
Next: using List Tablespaces Show Detail to free pages
From: MarkB on 11 Jan 2010 02:31
Hi Arun,

>
> SELECT * FROM table ORDER BY col1 COLLATE Latin1_General_CI_AS
> Is this possible in DB2? How?
>

Try this:
SELECT * FROM table ORDER BY collation_key_bit(col1, 'UCA500R1_S2')
note that you can adjust the 2-nd parameter of this function according
to your needs.
For more info please read this:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.nls.doc/doc/r0050489.html

Regards,
Mark B.
 | 
Pages: 1
Prev: db2cli.ini
Next: using List Tablespaces Show Detail to free pages