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.
API | Source Text Storage Option Specification |
---|---|
BTEQ | As COMPILE command parameter. |
CLIv2 | With SPOptions parcel using DBCAREA extension Initiate Request. |
ODBC | As parameter. Form depends on 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).