MVSFORUMS.com

deepa12 · Posted: Fri Jan 27, 2006 5:00 am Post subject: re. retrieval order

say i have a table
EMP . It has other fields other than EMPNO which is primary key which is emno,deptno
when i say

kolusu · Posted: Fri Jan 27, 2006 5:43 am Post subject:

deepa12,

The retrieval of data depends on how the table is loaded. you might be able to retrive records on primary key sequence immediately after a re-org

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

To say it short:

Without coding an ORDER BY clause, you cannot be shure (over time, whatever happens to the table) about the sequence of rows in your answer set.

regards
Christian