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.