15.00 - 6883 Cannot specify both Protected and Compile options for UDT Ordering or Transform routine %FSTR. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

6883 Cannot specify both Protected and Compile options for UDT Ordering or Transform routine %FSTR.

Explanation:

If a User Defined Function(UDF) or User Defined Method(UDM) is an Ordering or Transform routine for a User Defined Type(UDT), the ALTER FUNCTION/METHOD command cannot specify both the PROTECTED optioin and the COMPILE option for the UDF/UDM in one single command.

Generated By:

OPD Alter UDF module

For Whom:

End User

Remedy:

Submit the request in two ALTER FUNCTION/METHOD commands. E.g. Alter Function MyFunc execute Protected; Alter Function MyFunc compile;