Hello EveryOne,
I have a task which is making me crazy to find the solution
The task is
------------------
1)Lets say i am having an table where i have 10 rows.
I will execute the query to get the all the rows in the table and i will note down the time when i have retrieved the rows.
NotedTime = date;

2)Now after some time i wanted to fire a query which should return be back the rows entered after the time stamp what have noted.. that is ntohing but notedtime...
i dont know any thing about the table i mean how many columsn are there or the data type anything...

Is it possible to fire such query ...
I tried searching in google about this probem but i could not find any information..
I would really appreciate if some one can reply..
Please let me know if the question is not clear...

Thanks,
Swati

If the table has a column of type timestamp that gets set to the current time when a row is inserted, then yes it is possible to do what you want.

Andy

Yes i do agree with your answer..I dont have timestamp in my data base table...I can not add or update the existing table that is the requirement..
Now is it possible....

No, it is not.

Andy

I was going to ask if you can see how many fingers I am holding up, but then it hit me...

If the mountain wont come to you, you should go to mountain. What I mean by this and this is really crazy to do it and I would not want to do it this way, but that is me.

Can you create a trigger on this table? You are not changing the table per say. If yes, create a trigger that will get fired up on any IUD and writes PK to a temp table along with putting timestamp into it. Then you can do what you are asking. But as I said, I would be against this method if it was presented to me

Hello Guys,

Hello Guys,
As a part of my research for the above issue.
I came to know about some thing called "ROWID"
For every DB2 table all the ROWIDs will be stored in some system table.
If i can get the the last rowID of a table before doing my stuff.
once i am donw with my stuff can i check in the same system table that after that noted rowid is there any new rowids....?
If yes then how what could be the query..

I would really appreciate if some one can help me out on this issue.

Thanks,
Swati

rowid for table
select row_number() over(), column_name from tabname
its there in table itself, does it stores in system tables , i m not sure on this ??
regds
Paul

which version are you on ?

9.5 : Optimistic locking

RID_BIT and RID scalar functions

The ROWID would be assigned by the database when the row is inserted. If rows are deleted, my guess is that DB2 will reuse the ROWIDs of the deleted rows. Also if a reorg occurs, the ROWIDs will change. You really cannot rely on this method. You really have to have a column that designates when the row was touched, so you can use that.

Andy