Specifies behavior for creating or replacing Teradata stored procedures.

データ型

string

デフォルト値

""

解説

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.