Data Model > Accessing the UNICOM Intelligence Data Model > Working with the Case Data Model > SQL syntax
 
SQL syntax
The Provider supports a subset of the SQL language. The following is a summary of the basic SQL support.
DDL statements
Simple data definition language (DDL) statements are available to create and drop summary tables and to create and drop variables in the response table.
See DDL statements.
SQL queries
A basic select statement is implemented 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 SQL queries.
Data manipulation statements
Basic update, insert, and delete statements are supported. The truncate statement is supported in UNICOM Intelligence Data Model 2.8 and later. The select into statement is not supported. It is intended that most data manipulation should occur using the ADO recordset interface.
See Data manipulation statements.
Execute stored procedures
The execution of extended stored procedures is possible using the execute command. The creation of stored procedures and dynamic SQL are not supported. Because stored procedures are not supported, control structures are not needed.
See EXECUTE: execute stored procedures.
Session, connections, and transactions
There is no SQL syntax support for session, connection and transaction management. For example it is not possible to issue a commit by executing an SQL commit statement. Transaction commits are performed programmatically using the OLE DB / ADO interfaces.
See also
Reserved keywords
Working with the Case Data Model