15.00 - SQL Procedure Options - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

SQL Procedure Options

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

 

This option …

Does the following …

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 manuals for details.

The ALTER PROCEDURE [NO] WARNING option enables suppression of all procedure compilation warnings. See “ALTER PROCEDURE (SQL Form)” on page 28 for details.