Entering a Query - SQL Assistant

Entering a Query

After establishing a connection to a data source (refer to “Connecting to and Disconnecting from a Data Source” on page 32), Teradata SQL Assistant is ready to execute queries. (Queries can be entered before a connection is established.)

To enter a query

✔ Do one of the following:

Click within the Query Window and enter a statement.

On the toolbar click , and enter a statement in the new Query tab.

Select File > New Query and enter a statement in the new Query tab.

Press Ctrl+N and enter a statement in the new Query tab.

From the History window, select any statement from the SQL statement column.

The Execute command submits the query currently in the Query Window to the database. Each statement in the query is submitted separately to the database. By default, queries are submitted asynchronously and can be aborted while they are executing.