IBM Mainframe Forum

I have a table with 5 columns and 3 indexes .
the table already had few rows, i newly inserted few row to the table , and when i queried the table the rows fetched were out of order. the highlighted rows are inserted by me.

cola -- has a clustered index in ascending order
colb -- has a non clustered index in ascending order
cole -- has a non clustered index in ascending order

I tries to rebuild and reorg all the 3 indexes and still the data order remains the same. can any body pls help me out.

cola colb colc cold cole

09/01/2009 09/18/2009 10/15/2009 10/15/2009 11/15/2009
10/01/2009 10/20/2009 11/15/2009 11/15/2009 12/15/2009
11/01/2009 11/17/2009 12/15/2009 12/15/2009 01/15/2010
12/01/2009 12/18/2009 01/15/2010 01/15/2010 01/31/2010
12/01/2010 12/21/2010 01/15/2011 01/15/2011 01/31/2011
11/01/2010 11/19/2010 12/15/2010 12/15/2010 01/15/2011
10/01/2010 10/20/2010 11/15/2010 11/15/2010 12/15/2010
09/01/2010 09/21/2010 10/15/2010 10/15/2010 11/15/2010
08/01/2010 08/20/2010 09/15/2010 09/15/2010 10/15/2010
07/01/2010 07/21/2010 08/15/2010 08/15/2010 09/15/2010

Try REORGing the tablespace as well. It will then unload the data, sort it and load it back in the correct order. Try that and see what you get.

Hello,

when i queried the table the rows fetched were out of order

Sorry, but no. . .

If you do not specify an ORDER BY, there is no "out of order". If you want rows returned in a particular order, you need to specify this in your query.