ASA SQL Reference
  SQL Statements

START LOGGING statement [Interactive SQL]

Description 

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

Syntax 

START LOGGING filename

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

Permissions 

None.

Side effects 

None.

See also 

STOP LOGGING statement [Interactive SQL]

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not applicable.

Example 

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

START LOGGING 'c:\filename.SQL'