You can generate SQL Views by setting the Deploy SQL Views folder configuration property to True. Refer to the Agile Business Suite Developer User Guide for more information.
Maintenance of views occurs automatically during reorganization.
As part of the generation, SQL Views are created or dropped, as appropriate:
If a System without SQL Views is generated with SQL Views selected, all SQL Views are created.
If a System with SQL Views is generated with SQL Views selected, existing SQL Views are created, replaced, or dropped as appropriate.
If a System with SQL Views is generated with SQL Views unselected, existing SQL Views are dropped.
Note: Generation time and disk usage increases if you choose to generate SQL Views.
Files containing view maintenance commands are created in the system directory. The files are described in the following table:
| Views of | View Name |
|---|---|
| VIEWS.sql | Used for creating views in SQL Server. |
| VIEWS.dsid.sql | Used for dropping views in SQL Server. |
| EVENTS.ext | Stores events and its dependencies. |
The files VIEWS.sql, VIEWS.dsid.sql, and EVENTS.ext are removed if you choose not to generate SQL Views. Otherwise the files are retained.