Is there anyway to alter a view once it has been created? We sometimes have views calling many other views (for instance, View5 references View4, which references View3, which references View2, which references View1). At the moment, we haven't found a way to "alter view" so we have to delete it and recreate it. This results in the deletion of object dependcies...so all views have to be recreated.
Any suggestions? We are using iSeries Navigator for AS400 DB2.