SQL Procedure Options - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

SQL procedures have 1 user-specified attribute, the source text storage option, as detailed in the following table.

SPL Option Description
SPL Stores the DDL definition source text of the procedure in the dictionary.

SPL is the default option.

NO SPL Does not store the source text of the procedure in the dictionary.

You can specify this option in different ways from the different client utilities and interfaces from which the procedure is created, as described by the following table.

FOR this API … SPECIFY the source text storage options in this way …
BTEQ as a parameter of the COMPILE command.
CLIv2 with the SPOptions parcel using the DBCAREA extension Initiate Request.
ODBC as a parameter specified in different ways depending on the platform.

See the appropriate Teradata Tools and Utilities documents.

The ALTER PROCEDURE NO WARNING option enables suppression of procedure compilation warnings. See ALTER PROCEDURE (SQL Form).