Please enable JavaScript to view this site.

Navigation: » No topics above this level «

Invantive UniversalSQL

One of the most familiar questions at our support desk is "what functions are available" in Invantive UniversalSQL to query data in Exact Online.

This second-generation SQL parser is an extensive implementation of many commonly found SQL constructs from the ANSI SQL standard.

It includes in addition to the features of the first-generation SQL parser also:

joins,

outer joins,

cross joins,

group functions such as stddev, avg and listagg,

value functions such as xmlescape and round.

There are two flavors shipped:

Free version: second-generation SQL parser without joins and some upcoming non-ANSI standard advanced mapping functions for large volume financial analysis and reporting.

Paid version: identical to the free version but with joins and advanced mapping functions.

The EBNF-grammar in Grammar depicts the possibilities.