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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)
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.