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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Administering Your Database » SQL Anywhere graphical administration tools » Using Interactive SQL » Executing SQL statements from Interactive SQL


Logging commands

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

To begin logging Interactive SQL commands

  1. From the SQL menu, choose 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.

To stop logging Interactive SQL commands

  • From the SQL menu, choose Stop Logging.


You can also start and stop logging by typing in the SQL Statements pane. To start logging, type and execute START LOGGING 'c:\filename.sql', where c:\filename.sql is the path, name, and extension of the log file. You only need to include the single quotation marks if the path contains embedded spaces. To stop logging Interactive SQL commands, type and execute STOP LOGGING.

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