data caching in web application and checking file update (again )

[Ashish Kulkarni <kulkarni_ash1312@xxxxxxxxx>]

Hi
Some how my last email did not came through i guess
I am working on a web application where databsed is
DB2 on AS400, i have a table which has lot of data, i
want to cache this data in application server to
improve performance, 
How do i find out if any of the records in the table
are updated or added or delted by some other process
like a green screen application??
I want to have some kind of trigger to update the data
cache as soon as table contents are modified
I cannot make any change on database so have to have
some external triggers. is it possible by using any
classes in JT400 package,
Also what is the best way to cache data in applicaton
server??
Ashish


                
__________________________________ 
Do you Yahoo!? 
All your favorites on one personal page ? Try My Yahoo!
http://my.yahoo.com