Built-in functions for opaque data types
The database server provides special SQL-invoked functions, called built-in
functions, that provide some basic mathematical operations.
The built-in functions that the database server provides handle the
built-in data types. You can overload a built-in function to provide
the associated operation on your new opaque data type. If you overload
a built-in function, follow these rules:
- The name of the built-in function must match the name listed in Built-in functions that you can overload. However, the name is not case sensitive; the abs() function is the same as the Abs() function.
- The built-in function must be one that can be overridden.
- The built-in function must handle the correct number of parameters, and these parameters must be of the correct data type.
- The built-in function must return the correct data type, where appropriate.
For more information about built-in functions, see the HCL OneDB™ Guide to SQL: Syntax.