Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Data import and export » SQL script files

 

Running a SQL script file without loading

In Interactive SQL, you can run a SQL script file without loading it into the SQL Statements pane.

Prerequisites

Ensure that Interactive SQL is set up as the default editor for .sql files.

In Interactive SQL, click Tools » Options » General and then click Make Interactive SQL the default editor for .SQL files and plan files.

The privileges required depend on the statements being executed.

Context and remarks

The Run Script menu item is the equivalent of a READ statement.

 Task
  1. In Interactive SQL, click File » Run Script.

  2. Locate the file, and click Open.

Results

The contents of the specified file are run immediately. A Status window appears to show the execution progress.

 See also