SET SQLCOMPILE
SET SQLCOMPILE
Controls the compilation of generated SQL statements within the SQL database.
Syntax
SET SQLCOMPILE ON|OFF
Comments
The SQLCOMPILE option is OFF by default. The software stores SQL statements generated in the compiled code and executes them dynamically at run time.
When SQLCOMPILE is switched ON, the software attempts to compile all generated SQL statements at the SQL database server. Before attempting to compile with SQL compiling switched on, you must be connected to the SQL database.
Changes to this setting provide control over how the SQL statements are to be executed. The query optimizers for certain SQL databases perform differently when processing SQL statements dynamically.
Example
set sqlcompile off
list all Customers format CC LastName
set sqlcompile on
Forces the statement list all Customers format CC LastName to be executed dynamically at the server within a compiled application program.
See Also