Query Development | Running SQL | Teradata Studio/Studio Express - Running SQL - Teradata Studio

Teradata® Studio™ Express User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
ovm1576517377363.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
lifecycle
previous
Product Category
Teradata Tools and Utilities
Use any of the following options 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.
  • Running database objects - Several types of objects can be "run" in from the Data Source Explorer.

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 tabs 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.