Specifies behavior for creating or replacing Teradata stored procedures.

Data Type

string

Default Value

""

Remarks

SPSPL=SPL (the default) directs the Teradata Database to store Stored Procedure Language (SPL) source text when a stored procedure is created. SPSPL=NOSPL directs the Teradata Database not to store Stored Procedure Language (SPL) source text. If a stored procedure is created without source text, the SHOW PROCEDURE statement will return an error.