JanaBala@5

RDBMS distribution

Discussion created by JanaBala@5 on May 5, 2017
Latest reply on May 8, 2017 by cramsey

HI

 

I am having issue implementing DISTRIBUTION on RDBMS Interface.

 

SQL QUERY:

select timestamplocalsystem AS PI_TIMESTAMP,  COL1 AS pi_value1,0, COL2 AS pi_value2,0

from [SCADAHistorical].[dbo].[banana] H

FULL OUTER JOIN [SAConfiguration].[dbo].[DeviceName] C

ON

C.SystemNumber=H.SystemNumber

where timestamplocalsystem >= (getdate()-1) and timestamplocalsystem <= getdate() and C.DeviceName=?;

 

SQL DATA Table:

 

TAG CONFIG:

 

outcome for this solution:

Its writing all the values in one tag(first tag).

Outcomes