Logging Commands

With the Interactive SQL logging feature, you can record commands as you execute them. Interactive SQL continues to record until you stop the logging process, or until you end the current session. The recorded commands are stored in a log file.

Start or stop logging:

Command	Description
Start logging	You can use either: The GUI option: Choose SQL > Start Logging. In the Save dialog, specify a location and name for the log file. Click Save when finished Enter the command, where c:\`file_name`.sql is the path, name, and extension of the log file: start logging "c:\`file_name`.sql" A log file must have the .sql extension. Include the single quotation marks if the path contains embedded spaces. Once you start logging, all commands that you try to execute are logged, including ones that do not execute properly.
Stop logging	You can use either: The GUI option by choosing SQL > Stop Logging. Enter the command: stop logging .

Command

Description

Start logging

You can use either:

The GUI option:
1. Choose SQL > Start Logging.
2. In the Save dialog, specify a location and name for the log file.
3. Click Save when finished
Enter the command, where c:\file_name.sql is the path, name, and extension of the log file:
```
start logging "c:\file_name.sql"
```
A log file must have the .sql extension. Include the single quotation marks if the path contains embedded spaces.

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

Stop logging

You can use either:

The GUI option by choosing SQL > Stop Logging.
Enter the command:
```
stop logging
```
.

Note: The commands start logging and stop logging are not Transact-SQL commands, and are not supported by SAP ASE outside the Interactive SQL dialog box.