Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    42

    Unanswered: v9.5: CREATE DB with locale-sensitive-collation

    I am trying to create a db with locale-sensitive-collation but I get syntax error or more precisely the collation algorythm is not recognized.

    db2 create db t automatic storage yes using codeset utf-8 territory dk \
    collate using UCA500R1_LDA pagesize 16 k

    SQL0204N "UCA500R1_LDA" is an undefined name. SQLSTATE=42704

    This is running on db2 v9.5 express-c edition.

    DB21085I Instance "db2i95" uses "32" bits and DB2 code release "SQL09050" with
    level identifier "03010107".
    Informational tokens are "DB2 v9.5.0.0", "s071001", "LINUXIA3295", and Fix Pack
    "0".
    Product is installed at "/opt/ibm/db2/V9.5".

    The way I read the manual, the above command should work.

    Do you guys have an idea what might be wrong?

    Thanks in advance,
    Alexander

  2. #2
    Join Date
    Nov 2003
    Posts
    42

    v9.5: CREATE DB with locale-sensitive-collation (SOLVED)

    Ups. My fault. I need db2 v9.5 FP1 to use this feature.

    It works.

Posting Permissions

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