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"