Purpose
Takes input arguments and returns a single value result.
Syntax
udf_name ( [ argument [,...] ] )
For UDFs that are defined with parameters of TD_ANYTYPE data type:
( udf_name { () RETURNS { data_type | STYLE column_expr } | ( argument [,...] ) [ RETURNS { data_type | STYLE column_expr } ] } )
- udf_name
- The name of the scalar UDF.
- argument
- A valid SQL expression.
- data_type
- The desired return type of the TD_ANYTYPE result parameter.
- column_expr
- A table or a view column reference that determines the return type of the TD_ANYTYPE result parameter.