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

To log SQL statements generated by Sybase Central

  1. Choose View » Server Messages And Executed SQL.

    The Server Messages And Executed SQL pane appears at the bottom of the Sybase Central window.

  2. Right-click in the Server Messages And Executed SQL pane and choose Options.

    The Options window appears.

  3. Specify the settings. If you want to save the logging information to a file, click Save.