Logging statements in Interactive SQL

The Interactive SQL logging feature records SQL statements as you execute them. Statements are recorded until you stop the logging process or end the current session.

Prerequisites

There are no prerequisites for this task.

Context and remarks

You can start or stop logging using either the SQL menu, or SQL statements.

The recorded statements are stored in a log file so you can use the statements again.

Once you start logging, all SQL statements that you try to execute are logged, including ones that do not execute properly.

Task

Open Interactive SQL.

To start logging:

Option

Action

SQL menu

Click SQL » Start Logging.
In the Save As window, specify a location and name for the log file. For example, name the file mylogs.sql.
Click Save when finished.

START LOGGING statement

Execute a START LOGGING statement.

For example, to start logging to a file named c:\mylogs.sql, execute the following statement:

START LOGGING 'c:\mylogs.sql';

To stop logging:

Option

Action

SQL menu

Click SQL » Stop Logging.

STOP LOGGING statement

Execute the following statement:

STOP LOGGING;

Results

Statement logging in Interactive SQL is started or stopped.

Logging statements in Interactive SQL

Task

See also