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.