Running SQL - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
cev1468860002862.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
Teradata Studio has the following ways to run SQL operations on your Teradata systems:
  • The SQL Editor provides the ability to define and run SQL statements. See the Using the SQL Editor topic for details of how to run SQL statements from the SQL Editor.
  • Run Configurations let you define operations that you can run from the Run menu and Run toolbar button. See the Running SQL from Run Menu and Toolbar topic for details of how to specify run configurations and how to run them.
  • Running database objects - Several types of objects can be "run" in from the Data Source Explorer. See the following section for details.

Running Database Objects

Another way that operations can be performed in the database is by using the Run menu item in the pop-up menu shown when you right-click certain objects in the Data Source Explorer tree.

The types of objects that can be Run from the Data Source Explorer are (followed by the result of selecting Run):
  • Stored Procedures - Displays the Configure Parameters dialog box where the procedure's parameters are specified. The Stored Procedure is called with the specified parameters. The values of the parameters after the call is completed, including the OUT and INOUT parameters, are shown in the Parameters tab of the SQL Results view.
  • User-defined Functions - Displays the Configure Parameters dialog box where the procedure's parameters are specified. The UDF is SELECTED with the specified parameters. The values of the parameters are shown in the Parameters tab of the SQL Results view. The value of the UDF is shown in the Result1 tab.
  • Macros - Displays the Configure Parameters dialog box where the procedure's parameters are specified. The macro is executed with the specified parameters. The results of the macro are shown in the Result tab(s) of the SQL Results view.
  • Triggers - Displays the Edit Configuration dialog box where the SQL statement that performs the operations that causes the trigger to be run is specified. The specified SQL statement is run and the results of the SQL operation are shown in the SQL Results view.

When SQL operations are performed using the Run menu item, a launch configuration specifying the way the operation was run is created. See the Running SQL from Run Menu topic for details of how to rerun, edit and remove the automatically created launch configurations.