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).