.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.