AnsweredAssumed Answered

PI AF SDK vs PI JDBC Driver - 'UpdateValue'

Question asked by AshishGupta on Jan 31, 2020
Latest reply on Feb 3, 2020 by gregor

Hi There,

I am working on PI JDBC client program to set tag values. By using AF SDK API's, for setting tag values we have used "UpdateValue" API of "OSIsoft::AF::PI::PIPoint" object. Here we are developing corresponding PI JDBC client program operations for "UpdateValue".We have observed that we have different cases while using the "UpdateValue" API as below
case1:"Insert"
case2:"InsertNoCompression"

 

For case 1 , I am using a jdbc query as follows
INSERT piarchive..picomp2 (tag,time,value) VALUES ('example_int32','2020-01-16 01:30:15','200');

 

Can someone please suggest what will be the jdbc query for case 2 ie "InsertNoCompression" and what is the difference between both the cases?

 

I have already refered https://techsupport.osisoft.com/Documentation/PI-AF-SDK/html/T_OSIsoft_AF_Data_AFUpdateOption.htm for PI AF server but I want the corresponding scenario for PI JDBC server. Can someone please help me in this

Thanks

Outcomes