We have a lot of complex SQL Views for using in WebQuery. Some Views are Views on Views.
If a table (or a view with a view over it) is deleted and recreated, the view is also deleted and I have lost all the SQL statements in the view.
Is there any way to avoid that the view will be deleted if the table is removed ?
(maybe the view will be set to inactive or gives an error message if it will be used).
I use only System i Navigator (I can'nt programming under green screen).