1. I am doing the following to identify like Views or Stored procedures that
go invalid because of a Table getting dropped and re-created?

select rtn.*
from syscat.routines rtn, syscat.routinedep rdep
where rtn.routineschema = 'RRODEV'
and rdep.routinename = rtn.specificname
and rtn.valid = 'Y';


2. How do I recompile them to make them valid again??


Thanks,

Surendar.

_________________________________________________________________
Get Married in 2007. Join Shaadi.com
http://www.shaadi.com/ptnr.php?ptnr=mhottag


DB2 & UDB email list listserv db2-l LazyDBA home page