• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

plz help me with my problem..

 
Jack Daniel
Ranch Hand
Posts: 163
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi e'body..
Is it possible to Insert tuples(Or rows) in any database table, in sequence order..
I am working with DB2...
because it would be great, ..
But right now, whats happening is.. ok if I run my sql query(SELECT).. and my required row is not the last row.. then the next Inserted row(INSERT) by another person will be just the next row of my
ResultSET row, but not the last row of the DB2 table.. maybe the cursor is just at the next row of my query..
I hope you are understanding, what I am trying to say..
I would be very grateful & thankful to anybody who can give me a solution.. & help me..
Thanks again.
 
John Haake
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As far as I know (I'm an Oracle DBA, not DB2), relational databases and SQL cannot guarentee any specific ordering of the result set unless it is specifically asked for (i.e. ORDER BY, or GROUP BY), otherwise the engine will get them back in whatever order is fastest (and in a heavily updated table that can be quite random).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic