Hello DB2 for i experts.
Our IBM i shop has many (really many) SQL views on the DB2 for i, and we wanted to script down dropping of all these views and recreating them so that we can use them whenever we upgrade our ERP release on IBM i.
We thought we could do a "right click" on the "VIEWS" folder under "Schemas" folder in the navigator, but when we did that it showed DDS LF and views and so do a mass "generate sql" wont help. Is this normal that the VIEWS folder in navigator shows DDS LF and SQL View.
Is there any quick way to get the SQL scripts for all the views (SQL views)?