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 » SQL Anywhere database connections » SQL Anywhere database servers » Database server action logging

 

Logging SQL statements

As you work with a database in Sybase Central, the application automatically generates SQL statements depending on your actions. You can keep track of these statements in a separate pane, called Server Messages And Executed SQL, or save the information to a file.

Prerequisites

There are no prerequisites for this task.

Context and remarks

The Server Messages And Executed SQL pane has a tab for each database and database server. The tab for database servers contains the same information as the database server messages window.

 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Log SQL statements generated by Sybase Central to the Server Messages and Executed SQL pane.

    1. Click View » Server Messages and Executed SQL.

    2. In the Server Messages And Executed SQL pane, click the tab with the database icon.

    3. Right-click and click Options in the dropdown menu.

    4. Edit the logging options.

    5. Click Save.

  3. Log SQL statements generated by Sybase Central to a file.

    1. In the left pane, right-click the database and click Start Logging Database Changes.

    2. Specify a file name and click Save.

Results

Database changes are logged.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0