How to Implement Custom SQL Scalar Functions in an ODBC Driver

▤ Summary

For example, a new in-memory database can calculate the average of N columns over a span of N tables extremely efficiently by calling a scalar function. In this blog, I will walk through a simple example of implementing a custom scalar function in the SimbaEngine SDK’s Quickstart sample. In this example our scalar function will check to see if there is an instance of the character ‘e’ in the string given as the input and store this result in a member variable in the class for later use. 1 : 0; return false; } • For the Simba SQLEngine to use the custom scalar function, you must implement a method in the data engine class called . For example, with the query and a data source that can handle the custom scalar function in the clause, we can implement a Expression handler to pass it down.

▦ Linked Companies

CALUMO

$5M to $10M