PI SQL Client ODBC limitations

Data types

The following data types are not supported:

• .NET (AF) Object

• COM Object

• VARIANT containing GUID

• VARIANT containing timestamp

Transactions

Manual transactions are not supported. Queries should be executed in auto-commit mode. If an application cannot use auto-commit, be aware that queries are executed immediately and commit has no effect. This also means that rollback has no effect.

Batch processing

Batch processing is currently not supported with the RTQP Engine.