Use this statement to start logging executed SQL statements to a log file.

Syntax

START LOGGING filename

Remarks

The START LOGGING statement starts copying all subsequent executed SQL statements to the log file that you specify. If the file does not exist, Interactive SQL creates 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 SQL » Start Logging and SQL » Stop Logging.

Permissions

None.

Side effects

None.

See also

• STOP LOGGING statement [Interactive SQL]
• Using Interactive SQL

Standards and compatibility

Example

Start logging to a file called filename.sql, located in the c: directory.

START LOGGING 'c:\filename.sql';