View previous topic :: View next topic
|
Author |
Message |
Chanchal Majumder
New User
Joined: 09 Jul 2012 Posts: 10 Location: INDIA
|
|
|
|
Hi ..I have loaded a table from region to same table of an another region .
But when i have loaded in a different region the internal sorting of the data is different.
Table 1 :
1 2
2 3
4 5
Table 1 :
2 3
4 5
1 2
So here Can any one please tell me Please ,in what basis db2 sort the data internally ?
So i can check for both the table and made them in sync .
Thanks & Regards,
Chanchal . |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
You should remember that when doing a select without an ORDER BY clause
the order in which the rows are returned is unpredictable and generally NOT reproducible ( the same query might return rows in a different order ) |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
So i can check for both the table and made them in sync . |
Why do you believe they need to be "in Sync?
In a database the physical placement of data rows should not be an issue?
As Enrico mentioned, if you want things to be the same, use an ORDER BY.
If i've mis-understood, please clarify. |
|
Back to top |
|
|
Chanchal Majumder
New User
Joined: 09 Jul 2012 Posts: 10 Location: INDIA
|
|
|
|
Yup ..I agree |
|
Back to top |
|
|
|