skip to main content
OpenAccess SDK SQL Engine core methods for Java : Exchanging data : Using Custom Scalar Functions in a WHERE Clause
 

Using Custom Scalar Functions in a WHERE Clause

Your IP can use custom scalar functions that are specified in a WHERE clause. For example, the following query specifies a scalar function named NEAR:
SELECT * FROM curvalue WHERE name = NEAR('tom', 'jones');
The OpenAccess SDK SQL engine allows the IP to obtain information about the custom scalar conditions and evaluate them, returning each set of custom conditions as a list of OR predicates. Your IP must complete the following procedure to evaluate and use custom scalar functions.
Note: This feature is not supported for .NET.