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:
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|