Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Location
    zxczxczxc
    Posts
    52

    Unanswered: How to read Time stamps of rows

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

  2. #2
    Join Date
    Nov 2004
    Posts
    143
    Hi,

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

    bye

  3. #3
    Join Date
    Apr 2004
    Location
    Brussels
    Posts
    57
    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
    Yves & Willy

  4. #4
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •