SQL queries
The UNICOM Intelligence Data Model supports a basic select statement for querying data. Expressions are supported, however sub-queries and joins are not supported. By supporting only a single query per statement only a single result set is returned. This avoids the need to support multiple results per execution. Cursor support is only provided using the programmer interfaces and not using SQL. Some SQL extensions are supported to enable crosstabulation on categorical variables.
See also