Contents Index Recalling commands Selecting Data from Database Tables

ASA Getting Started
  Using Interactive SQL
    Working with SQL statements in Interactive SQL

Logging commands


With the Interactive SQL logging feature, you can record commands as you execute them. Interactive SQL continues to record until you stop the logging process, or until you end the current session. The recorded commands are stored in a log file.

To begin logging Interactive SQL commands

  1. Choose SQL > Start Logging.

  2. In the Save As dialog, specify a location and name for the log file.

    A log file must have the .SQL extension.

  3. Click Save when finished.

To stop logging Interactive SQL commands

Tips 
You can also start and stop logging by typing in the SQL Statements pane. To start logging, type and execute START LOGGING 'c:\filename.sql', where c:\filename.sql is the path, name, and extension of the log file. A log file must have the .SQL extension. You only need to include the single quotation marks if the path contains embedded spaces. To stop logging, type and execute STOP LOGGING.

Once you start logging, all commands that you try to execute are logged, including ones that do not execute properly.


Contents Index Recalling commands Selecting Data from Database Tables