Log SQL statements in Sybase Central

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. 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.

When you work with Interactive SQL, you can also log statements that you execute. See Statement logging in Interactive SQL.

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

  1. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. Click View » Server Messages And Executed SQL.

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

  4. Right-click and click Options.

  5. Edit the logging options.

  6. Click Save.

 Log SQL statements generated by Sybase Central to a file (Sybase Central)

  1. Connect to a database.

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

  3. Specify a file name and click Save.

 Stop logging database changes (Sybase Central)

  • In the left pane, right-click the database and click Stop Logging Database Changes.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1