PierreMarcil

RDBMS Interface Vs PI_STATUS

Discussion created by PierreMarcil on May 7, 2013
Latest reply on Nov 16, 2015 by aguzu

Hello, i try to figure how to input a digital state "shutdown" within RDBMS query.  reading doc i see I might be able to use PI_STATUSx, but I can t make it work.

 

I have been trying something like this just for testing :

 

select cast('2013-05-07' as datetime) PI_TIMESTAMP, 'BCQ:PTRM:TEST' PI_TAGNAME1, 0 as PI_VALUE1, 'shutdown' PI_STATUS1;

 

Any tip/help/documentation would be appreciate, there is not much information on this in "Relational Database(RDBMS via ODBC) Interface, Version 3.19.1.x revision A"

Outcomes