Hi,
I need to read rows which are inserted later than a particular row.
eg;

If i have the following rows
f
e
c
a
x

is it possible to read only the rows after c(i.e a,b).

One way i feel is to know the timestamps of rows. Is there any other method to do so.


Bye.

Hi,

You can use the column "rowid" example "select *,rowid from table_name"

bye

I think you cannot use the rowid.
Under IDS7.31 I've tested it :
In my case the rowid of a deleted row was reused for a new created row.
create row a, b, c ; delete row b ; create row d, e,f
the result was that rowid of d = rowid of b < rowid c

Hi,

There is no possibilitie to solve this problem correctly. IDS has a 'timestamp' for all data but it is defined as following:
- on a page base (so multple records have same id)
- is not really a time but a seq. no
- seq. no is adjusted with every write achtion to the page
- possible write actions are: insert, update, deleta (but also backup if page
becomes rather old)

The best solution is to add a timestamp field to the record or maybe add crcols which are normally used for enterprise replication. The will hold two extra fields a user name and the timestamp. The fields can be accessed by using the specific column name, when select * they are not shown. See the ER guide for more info.

Greetz,

Rob Prop