Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL


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.


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.

  1. Open Interactive SQL.

  2. To start logging:

    Option Action
    SQL menu
    1. Click SQL » Start Logging.

    2. In the Save As window, specify a location and name for the log file. For example, name the file mylogs.sql.

    3. 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';
  3. To stop logging:

    Option Action
    SQL menu

    Click SQL » Stop Logging.

    STOP LOGGING statement

    Execute the following statement:



Statement logging in Interactive SQL is started or stopped.

 See also