Executing a Query Saved To a File - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Executing a Query Saved To a File

To simplify the use of large queries and for those who store their queries in a file, enter the following query where <filename> is the fully qualified name of a file containing the query to execute.

RUN <filename>

For example, RUN c:\temp\myquery.sql

The run statement must be the only statement in the Query Window. A filename can be followed by a semicolon. All text between the word RUN and the optional semicolon are assumed to be a part of the file name.

The query is processed exactly as though it had been entered in the Query Window, but the SQL stored in the history file is the run statement itself, not the actual query that was executed.