Recompile inoperative Views or Stored Procedures....

Recompile inoperative Views or Stored Procedures....

 

  

When I make table changes, I always re-create dependent Views and Stored
Procedures.

Is there a way to Recompile the Views that are inoperative?? And how do I do
the same for Stored Procedures??


Thanks,

Surendar.

_________________________________________________________________
Tried the new MSN Messenger? It’s cool! Download now.
http://messenger.msn.com/Download/Default.aspx?mkt=en-in


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