Please forgive a newbie question.

In MSSQL I can execute a stored procedure (sp_helpsort) that returns the
sort order (listing characters) of a database. Is there a DB2 equivalent
to this query?



--
Jono

Jon Hunt wrote:

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Serge Rielau <srielau (AT) ca (DOT) ibm.com> wrote on Fri, 08 Apr 2005 12:34:05
GMT:

"Returns" simply means the result of the query. If I execute sp_helpsort
on a database I get a result like this...

Unicode data sorting
----------------------
Locale ID = 33280

case sensitive


Sort Order Description
------------------------------------------------------------------------
------------------------------------------------------------
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 50, bin_iso_1
Binary Sort Order for the ISO 8859-1 (Latin 1) Character Set

Characters, in Order
------------------------------------------------------------------------
------------------------------------------------------------
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?
@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _
` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ *
¡ ¢ £ ¤ ¥ ¦ § ¨ © ª « ¬ * ® ¯ ° ± ² ³ ´ µ ¶ · ¸ ¹ º » ¼ ½ ¾ ¿ À
Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Õ Ö × Ø Ù Ú Û Ü Ý Þ ß à
á â ã ä å æ ç è é ê ë ì í î ï ð ñ ò ó ô õ ö ÷ ø ù ú û ü ý þ ÿ



--
Jono

Jon Hunt wrote:
http://publib.boulder.ibm.com/infoce...6e%66%6f%22%20

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Serge Rielau <srielau (AT) ca (DOT) ibm.com> wrote on Sat, 09 Apr 2005 01:56:01
GMT:

I'll take a look, thank you.


--
Jono