This setting allows you to specify whether the SQL statements generated while Dexterity application is running will be written to a log file as they are generated.
SQLLogSQLStmt=option
• option - A boolean that indicates whether the SQL statements generated while a Dexterity application is running will be written to a log file named DEXSQL.LOG. It can be set to one of the following:
![[spacer]](1p.gif){kind=small}
|
Value |
Description |
|---|---|
|
TRUE |
The SQL statements generated will be written to the file DEXSQL.LOG. This file will be stored in the location specified by the SQLLogPath setting. |
|
FALSE |
The SQL statements generated won’t be written to a log file. |
If the SQLLogODBCMessages setting is included in the defaults file and set to TRUE, the ODBC messages generated during the execution of Dexterity will be written to the same file. If both settings are included in the defaults file and set to TRUE, the ODBC messages will be intermixed with the SQL statements in the DEXSQL.LOG file. This will allow you to easily associate related ODBC messages and SQL statements.
If this setting isn’t included in the defaults file, the SQL statements generated while a Dexterity application is running won’t be written to the log file.