AnsweredAssumed Answered

Is there a PRINT command in the basic SQL commands available in PI SQL Commander ?

Question asked by SalGarcia on Nov 21, 2017
Latest reply on Nov 21, 2017 by vkaufmann

I have the following very simple query to bring timestamp and value for two tags:

 

SELECT time,value FROM piarchive..picomp2

WHERE tag = 'TAG_A' AND time BETWEEN '2017-09-21 08:49:00' AND '2017-09-21 10:42:00'

UNION

SELECT time,value FROM piarchive..picomp2

WHERE tag = 'TAG_A' AND time BETWEEN '2017-09-21 08:49:00' AND '2017-09-21 09:42:00'

 

Now the output is a running table with no text to differentiate between the output from the first SELECT and the second SELECT, I was trying to use the PRINT command after the UNION statement to insert a string between the SELECTS, but the software doesn't seem to recognize the PRINT command.

Is there an equivalent command I can use? (PI SQL Commander 2016 R2)

 

Thanks

SGM

Outcomes