16.10 - Views - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
16.10
created_date
June 2017
category
User Guide
featnum
B035-2042-067K

The system provides multiple views and tools that allow you to explore, discover, and manage Teradata-supported databases, to develop and execute SQL queries, and to transfer data between databases.

Many of the views appear as tabbed panes in the perspective. Not every view applies to every perspective. This table shows the more commonly-used views in the system. Some views are explained in more detail below.

View Description
Data Source Explorer Contains the database object tree display in the Query Development and Data Transfer perspectives. You can create Connection Profiles to your Teradata Database systems and interact with database objects.
Project Explorer Provides a hierarchical view of the Projects and their resource files. You can select SQL files for editing or create new SQL files.
Details/Forms Displays specific details for the selected database object and allows them to be created or modified
Data Lab Provides access to your tables from a Teradata Data Lab.
SQL Editor Displays when an SQL file is opened. Initially, the SQL Editor is opened to provide an area to enter SQL statements. Double-clicking a file in the Project Explorer causes the file to be opened in the SQL Editor view.
Teradata SQL History Maintains a list of SQL queries issued from the SQL editor, allowing you to re-execute them.
Teradata Result Set Viewer Displays the result set returned by SQL queries issued from the SQL Editor view. Individual Result Set tabs are created for each result set.

If a CALL to a stored procedure that has OUT or INOUT parameters is run, a tab is shown in the Result Set Viewer that contains the output values of the parameters.

Transfer History Provides a display of the Data Transfer History information in the database. When a data transfer completes, an entry is placed in the Transfer History.
Transfer Progress Displays a list of executing data transfer jobs and their status.