START LOGGING statement [Interactive SQL]

Starts logging executed SQL statements and messages to a log file.

Syntax

START LOGGING filename

Remarks

The START LOGGING statement starts copying all subsequent executed SQL statements and messages to the log file that you specify. If the file does not exist, Interactive SQL creates it. If the file does exist, Interactive SQL will append to it. Logging continues until you explicitly stop the logging process with the STOP LOGGING statement, or until you end the current Interactive SQL session.

You can also start and stop logging by clicking Start of the navigation path SQL Next navigation step Start Logging End of the navigation path and SQL Stop Logging .

Execution times are included in the log file when logging and execution time reporting are both enabled.

Privileges

None.

Side effects

None.

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

This example starts logging to a file c:\temp\sql.log:

START LOGGING 'c:\\temp\\sql.log';