Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    1

    Unanswered: Determining DB2 collating sequence

    We are just trying to determine the collating sequence (IDENTITY v. SYSTEM) on our DB2 db.
    We are running DB2 UDB 7.2

    Any suggestions.
    Thank you.

  2. #2
    Join Date
    Oct 2001
    Posts
    68
    You could try this simple script. You need to be connected to an instance/database.
    Code:
    Ohare:wpsulliv: db2 -svtf colate.sql
    create table colseq (key1 char(1))
    DB20000I  The SQL command completed successfully.
    
    insert into colseq values('a'),('A'),('b'),('B')
    DB20000I  The SQL command completed successfully.
    
    select * from colseq order by key1
    
    KEY1
    ----
    a
    A
    b
    B
    
      4 record(s) selected.
    I'm sure there's a catalog entry somewhere. I'll have to look it up when I get home.

    WP

Posting Permissions

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