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:
> 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?
Can you clarify what "returns" means? Can you post an example?

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

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

>> 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?
> Can you clarify what "returns" means? Can you post an example?

"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:
> Serge Rielau <srielau@ca.ibm.com> wrote on Fri, 08 Apr 2005 12:34:05
> GMT:
>
>
>>>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?
Best start with this link:
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@ca.ibm.com> wrote on Sat, 09 Apr 2005 01:56:01
GMT:

> Jon Hunt wrote:
>> Serge Rielau <srielau@ca.ibm.com> wrote on Fri, 08 Apr 2005 12:34:05
>> GMT:
>>
>>
>>>>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?
> Best start with this link:
> http://publib.boulder.ibm.com/infoce...om.ibm.db2.udb.
> doc/admin/r0000287.htm?resultof=%22%63%6f%6c%6c%61%74%65%5f% 69%6e%66%6f
> %22%20

I'll take a look, thank you.


--
Jono