Debugging

Execsql includes several metacommands that will display elements of its internal environment, to asssist with script debugging.

DEBUG LOG SUBVARS

Writes all substitution variables to the log file.

DEBUG WRITE SUBVARS [[APPEND] TO <filename>]

Writes all substitution variables to the terminal or to the specified text file.

DEBUG LOG CONFIG

Writes configuration settings to the log file.

DEBUG WRITE CONFIG [[APPEND] TO <filename>]

Writes configuration settings to the console or to the specified text file.

DEBUG WRITE ODBC_DRIVERS [[APPEND] TO <filename>]

Writes the names of available ODBC drivers to the console or to the specified text file. ODBC drivers are used with SQL Server and MS-Access.

DEBUG WRITE <script_name> [[APPEND] TO <filename>]

This is an alias for the WRITE SCRIPT metacommand.