xSQL Analytics (Statistical) Functions Samples

The samples/xsql/scripts/financial directory contains a number of command and script files to facilitate running select commands to demonstrate groups of statistical functions. These command files invoke xSQL and run scripts to demonstrate the SQL Analytics Functions by category. The examples in categories 1-5 can be run using the command file f.bat (f.sh in Linux systems) and categories 6-11 can be run using g.bat (g.sh in Linux systems). Simply type f or g followed by a space and the category number to run the SQL script.

For instance, to experiment with the “Binary” functions, type

 
    f 3
     

To experiment with the “Grid Agg” functions, type

 
    g 7
     

The command file invokes xSQL with the appropriate SQL script files. The individual script files define and initialize specific sample tables appropriate to the functions being demonstrated, then perform the individual select statements described in the associated pages. (Please refer to the SQL Analytics Functions page for details about these groups of functions.)