12. Report-Writer Statements : Report Setup Statements : .Cleanup Statement—Embed SQL Statements that Clean Up
 
Share this page                  
.Cleanup Statement—Embed SQL Statements that Clean Up
The .cleanup statement embeds SQL statements that do not involve data retrieval into Report-Writer sections. Report-Writer executes the statements after the main report query is processed.
The .cleanup statement has the following format:
.cleanup SQL_statement; {SQL_statement;}
The parameters for the .cleanup statement are:
SQL_statement
One or more action SQL statements that do not involve data retrieval, separated by semicolons (;).
Note:  The select statement cannot be used.
For a complete explanation of all available statements, see the SQL Reference Guide.