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
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.