Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    14

    Unanswered: Linguistic Sorting

    How to do have the Linguistic Sorting in DB2. I know oracle provides it by NLSSORT feature. NLS_SORT is a init.ora parameter which does the sort based on the language. I want to know how it is to be implemented in DB2.


    Thank you.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Linguistic Sorting

    I think you may want to look at the 'collating sequence' in db2 ...

    AFAIk, in DB2 this is not configurable , but it has to be decided when creating the database itself

    Cheers
    Sathyaram



    Originally posted by treddy123
    How to do have the Linguistic Sorting in DB2. I know oracle provides it by NLSSORT feature. NLS_SORT is a init.ora parameter which does the sort based on the language. I want to know how it is to be implemented in DB2.


    Thank you.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jan 2004
    Posts
    14

    Re: Linguistic Sorting

    Hello Satya:
    Thank you for your suggestions. Can you give me some pointers on how to implement at the the database creation level. My database has to support the Multi Linguial data insertion.

    Thank you



    Originally posted by sathyaram_s
    I think you may want to look at the 'collating sequence' in db2 ...

    AFAIk, in DB2 this is not configurable , but it has to be decided when creating the database itself

    Cheers
    Sathyaram

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    The simplyest way is to use DB2 Control Center.
    1. Click pluses until you get Databases folder.
    2. Right-click and select Create | Database using Wizard.
    3. Follow the wizard (at the Region page it will give you a territory info to choose).

    Hope this helps,
    Grofaty

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •