xSQL Sample Functions

This sample demonstrates the use of several built-in functions including: sum(), substr(), length(), upper(), lower(), format() and count(). Note the use of the trace command to display performance statistics for the queries.

This sample can be run from directory samples\xsql\scripts with the following command:

 
    ..\..\..\target\bin\xsql.exe -b -c xsql.cfg -f functions.sql