m.m.kulkarni

query on picalc via linked server

Discussion created by m.m.kulkarni on Jul 22, 2014
Latest reply on Jul 22, 2014 by michaelh

Hi,

 

I am trying to write a select query on the picalc table in the piarchive catalogue. The query is as below:

 

select * from piarchive..picalc where expr = 'tagval(''sinusoid'')' and time between '2014-07-18 16:56:00' and '2014-07-18 17:01:00' and timestep = '00:01:00'

 

The above query works fine in PI SQL commander. But if i run the similar query in the linked server:

 

select * from .[piarchive]..[picalc] where expr = 'tagval(''sinusoid'')' and time between '2014-07-18 16:56:00' and '2014-07-18 17:01:00' and timestep = '00:01:00'

 

I dont see any output in the linked server query. I dont see any error messages in the Linked server query but there are no output rows.

 

 

 

Pls suggest any solution to the above.

 

 

 

Thanks,

 

Manasi.

 

 

 

 

Outcomes