Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    30

    Red face Unanswered: Command to create case insensitive database ???

    Hi All,

    Can anyone help me out to create a case insensitive database.

    I had created database with different collating sequences , but no Luck

    I am working on DB2 8.1 on AIX and W2K

    All answers are welcommed


    Regards,
    Pushp

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

    I think that createing insensitive database is not posible.

    But you can do the UCASE or LCASE function to insert data into database. You can also use UCASE or LCASE function in select statements.

    Hope this helps,
    Grofaty

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I have heard rumors that there will be DB2 enhancements in the future that allows case insensitive searches.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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