Creating a Stored Procedure - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hop1484765174877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
Store procedures allow you to build complicated applications through a variety of features.
  1. In the Navigator, expand the Databases, right-click a database or user, and click Show Procedures. A list of the procedures defined in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
  2. In the Object List Viewer toolbar, click .

    A Create Procedures property form opens in the Details view.

  3. In the form, enter values for the new stored procedure.
  4. [Optional] Click the SQL category to see the SQL code that will be executed on the connected system to create the new procedure.
  5. Click Commit.
  6. Click OK. The property form shows the properties of the new stored procedure.