Chapter 2: Interactive SQL Commands

start logging

Description

Starts logging executed SQL statements to a log file.

Syntax

start logging file_name

Parameters

file_name: is the file to which you are logging the session.

Examples

Example 1

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

start logging 'c: n filename.sql'

Usage

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 selecting SQL | Start Logging and SQL | Stop Logging.

Permissions

Any user can execute this command.