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

Hi,

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

Grofaty

Could you please guide me on how to find the "code pages" on both the OS.

Thanks.