Hi,
We are facing a invalid objects problem , during DB2 upgrade to 10.5. We have been asked by sap to drop all view that belongs to a particular schema.
Could we get help on how to drop all views in a particular schema in db2 9.7 . we have around 300 views.
Regards,
Prakaash