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.
Once you start logging, all commands that you try to execute are logged, including ones that do not execute properly.
From the SQL menu, choose 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:
START LOGGING 'c:\mylogs.sql'; |
From the SQL menu, choose Stop Logging.
Run the following:
STOP LOGGING; |
When you work with Sybase Central, you can also log commands 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 © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |