.Setup Statement--Embed SQL Statements that Perform Set up
The .setup statement embeds SQL statements that do not involve data retrieval into Report-Writer sections. Report-Writer executes the statements before it processes the main report query.
The .setup statement has the following format:
.setup SQL_statement; {SQL_statement;}
The parameter for the .setup statement is as follows:
SQL_statement
One or more action SQL statements that do not involve data retrieval, separated by semicolons (;). (Note that the select statement cannot be used.)
For a complete explanation of all available SQL statements, see the SQL Reference Guide.