Scalar Function Support

The Simba Teradata ODBC Connector includes full support for all of the scalar functions that are supported by the Teradata Database instance that you connect to. The version of the Teradata Database instance determines which specific scalar functions you can call.

For a list of the scalar functions that are supported by your version of Teradata Database, see the SQL Functions, Operators, Expressions, and Predicates book from the Teradata Database documentation set.

When calling a scalar function, it is recommended that you place the function inside an ODBC escape sequence, as this prompts the connector to check if the scalar function is valid before attempting to call it. For example:

SELECT {fn MOD(x, y) }

For more information about calling scalar functions, see "Scalar Functions" in the ODBC Driver for Teradata User Guide.