I cannot find an online documentation for the syntax of the PI ODBS driver (2016R2, so current version). So not looking for OLEDB (-enterprise) syntax but ODBC, for querying PI Integrator Views. Anyone have a pointer to that?
When querying PI Views from PI ODBC, the PI ODBC documentation states to refer to the PI Integrator for Business Analytics documentation for the supported SQL syntax.
PI ODBC delegates all SQL commands via PI SQL DAS to the underlying query engine.
When connected to the PI Asset Framework (AF) Server, the built-in query engine of PI OLEDB Enterprise is used. Please refer to the PI OLEDB Enterprise User Guide for supported SQL syntax. When connected to a PI Server, the built-in query engine of PI OLEDB Provider is used. Refer to the PI OLEDB Provider User Manual for supported SQL syntax.
Thanks Stuart! That was the pointer i was looking for. Somehow it didn't register in my mind to look for the syntax in the integrator documentation!
Retrieving data ...