15. Creating Reports in OpenROAD : Setup/Cleanup
 
Share this page                  
Setup/Cleanup
The Setup/Cleanup command lets you embed SQL statements that do not involve data retrieval into Reporter. The Reporter utility executes setup statements before it processes the main report query; cleanup statements are processed after the main report query.
Embedded groups of SQL setup statements can perform tasks such as creating temporary tables for use in the report document. Reporter executes the setup statement after substituting Reporter utility variables into the SQL statements.
Embedded groups of SQL cleanup statements can perform tasks such as dropping temporary tables created in the setup section. Reporter executes the cleanup statement after substituting Reporter utility variables into the SQL statements.