With the Interactive SQL logging feature, you can record SQL statements as you execute them. Interactive SQL continues to record statements until you stop the logging process, or until you end the current session. 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.
Click SQL » Start Logging.
In the Save As window, specify a location and name for the log file. For example, name the file mylogs.sql.
Click Save when finished.
Execute a START LOGGING statement.
For example, to start logging to a file named c:\mylogs.sql, run the following statement:
START LOGGING 'c:\mylogs.sql'; |
Click SQL » Stop Logging.
Run the following statement:
STOP LOGGING; |
When you work with Sybase Central, you can also log statements that you execute. See Log SQL statements in Sybase Central.
In addition, execution times can be included in the log file when logging and execution time reporting are both enabled. See isql_command_timing option [Interactive SQL].
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |