CREATE PROCEDURE and REPLACE PROCEDURE Syntax Elements (SQL Form) - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™
database_name
user_name
An optional qualifier for procedure_name.
If not specified, the current default database is used.
procedure_name
Name of the SQL procedure to be created.
procedure_name must be unique within the database.
For information about naming database objects, see Teradata Vantage™ - SQL Fundamentals, B035-1141.
SQL_data_access
Specifies whether the procedure body accesses the database or contains SQL statements.
This clause is mandatory for all SQL procedures. See CREATE PROCEDURE (SQL Form) in Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 for descriptions of the SQL data access options.
number_of_sets
Number of dynamic result sets that can be returned.
The range of valid values for number_of_sets is 0 through 15, inclusive.
The default value for number_of_sets is 0.