Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    UK
    Posts
    52

    Unanswered: Collating Sequence problem

    Query results are getting displayed in different order. The 2 database servers are:

    (A) db2 v8 on Win2000 (development)
    (B) db2 on AS400 (production)

    I think this is a problem with the Collating Sequence used in both databases. I do not know much about db2 on AS400. I also understand that collating sequence cannot be modified and can only be set at the time of db creation.

    Now my query is, how to take care of this situation where I can have same order in the result set.

    Thanks,
    Gautam
    Last edited by gpeee; 07-06-04 at 04:36.

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

    Find out what are the code pages set on bouth operating system first.

    Grofaty

  3. #3
    Join Date
    Jan 2004
    Location
    UK
    Posts
    52
    Could you please guide me on how to find the "code pages" on both the OS.

    Thanks.
    Last edited by gpeee; 07-07-04 at 08:26.

Posting Permissions

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