View previous topic :: View next topic
|
Author |
Message |
deva
New User
Joined: 03 Nov 2005 Posts: 19
|
|
|
|
hi
I have one employee table if i updated the table now how to retrieve the updated rows from employee table |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
Hi Deva,
Quote: |
I have one employee table if i updated the table now how to retrieve the updated rows from employee table |
since the updation to take in effect u should refresh the table.. once the select or any other command is used in the mean the table get refreshed. so for ur case u can use the select command in order to get the effect.. |
|
Back to top |
|
|
deva
New User
Joined: 03 Nov 2005 Posts: 19
|
|
|
|
Hi khamaurutheen,
my question is how to retrieve only last updated rows. |
|
Back to top |
|
|
akashs
New User
Joined: 24 Nov 2005 Posts: 49 Location: chennai
|
|
|
|
we use SQLERRD(3) , to find how many rows have updated....but i dont know how to retreive the updated rows...
regards,
akash |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
Hi deva,
i think u can add a TIMESTAMP or TIMESTAMP WITH TIME ZONE column to the table . and using that u can retrive the updated row.. i don't think there will b any other way... let me c..... |
|
Back to top |
|
|
prasad43
New User
Joined: 21 Oct 2005 Posts: 7 Location: blore
|
|
|
|
Hi,
in vsam we cannot apply conditions to any fields or any files,and it is some what cost that's why better to use sql.
Regards,
PRASAD DAGGUBATI |
|
Back to top |
|
|
nikyojin
New User
Joined: 05 Oct 2005 Posts: 94
|
|
|
|
Hi Guys,
The only possible way in DB2 to get the previously updated rows (provided no Timestamp field is available or modified by the previous query) is to analyse the DB2 catalog.The tool Log Analyser is used for the same purpose.
Thanks,
Nikhil .S. |
|
Back to top |
|
|
|