Sort Order

[Jon Hunt]

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

[Serge Rielau]

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

[Jon Hunt]

Serge Rielau <sr*****@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

[Serge Rielau]

Jon Hunt wrote:

Serge Rielau <sr*****@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

[Jon Hunt]

Serge Rielau <sr*****@ca.ibm.com> wrote on Sat, 09 Apr 2005 01:56:01
GMT:

Jon Hunt wrote:

Serge Rielau <sr*****@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