AnsweredAssumed Answered

Help with RDBMS SQL Statement

Question asked by MartyWerner on Jan 6, 2018
Latest reply on Jan 8, 2018 by Srinivas

I am trying to setup an RDBMS interface and pull some data into the PI Arc using a data distribution tag. I have created the SQL statement and it works in my test tool but when I try to execute the statement with the interface it errors.

 

Any help would be greatly appreciated.

SELECT CONCAT (Concat(S.SMPL_DT ,' '),s.smpl_TM) AS PI_Timestamp, CONCAT(CONCAT (S.SMPL_PNT_NAME,'.'),R.PRPRTY_NAME) As PI_TAGNAME,  R.RSLT_VALUE AS PI_Value FROM IP_SMPL S, IP_TST_RSLT R WHERE  S.SMPL_DT = TRUNC(SYSDATE) AND S.SMPL_NAME = R.SMPL_NAME AND R.RSLT_VALUE IS NOT NULL AND S.EQ_NAME = 'CRUDE ASSAY' AND S.SMPL_PNT_NAME = 'CRUDE CVILLE'  ORDER BY S.SMPL_PNT_NAME, R.PRPRTY_NAME,S.SMPL_DT, S.SMPL_TM;

 

It appears it doesn't like the concat statements but they are required to get the correct data.

Outcomes