Import SQL

The Import SQL command takes a complete SQL statement from a text file, imports it into an existing query, and retrieve the data set from the database server. Use this feature to take advantage of SQL statements you have already written.

Before importing SQL files, make sure that the following conditions are true:

The SQL file to import begins with a SELECT statement.
The Query section is active.
The connection to the database is active.
The Content pane does not contain any tables.

You also need to know the number of columns to display in the Results section.

After you import the SQL file into the Query section, you cannot:

edit it
drag items from the table to the Request line
use the custom SQL feature
display its properties

However, you can specify a user-friendly name for the Request item and identify its data type.

To import SQL files:

Select File, then Import Data File, and then SQL.
The Import File dialog box is displayed.
Navigate to the location of the file.
Select the file to import and click OK.
Interactive Reporting prompts you for the number of data columns. The number that is by default in the dialog box is an estimate.
Type the number of columns and click OK.
Interactive Reporting inserts the SQL statement directly into the content, nested between the header and footer “Imported SQL Statement.” If the statement is larger than the visible Content pane, use the scroll keys to view it.