 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / DB2 Topics / April 2005Sort Order
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?  SignatureJono > 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 SignatureSerge 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 { | } ~ ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? SignatureJono > 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/infocenter/db2help/topic/com.ibm.db2.udb.doc/admin /r0000287.htm?resultof=%22%63%6f%6c%6c%61%74%65%5f%69%6e%66%6f%22%20 Cheers Serge SignatureSerge Rielau DB2 SQL Compiler Development IBM Toronto Lab Serge Rielau <srielau@ca.ibm.com> wrote on Sat, 09 Apr 2005 01:56:01 GMT: >> Serge Rielau <srielau@ca.ibm.com> wrote on Fri, 08 Apr 2005 12:34:05 >> GMT: [quoted text clipped - 6 lines] > 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. SignatureJono |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.