from openquery ([LPWVD4237,11210] , '
lm.[LM Status] as LM_Status
,lm.[lm removal dt] as LM_Removal_Dt
from loss_mit..LM_Inventory_History lm
where lm.lm_loan IN (''0633812755'')
and lm.[LM Status] IN (''R'') ' )
Hello i have a open query wherein i am trying to access sql server from teradata using open query - Quesy works fine in sql server. Getting an error - syntax error, expected something between word OPENQUERY and '(' . Could anybody know what i am missing.
Teradata simply doesn't support linked servers (In TD15 there's something similar, named QueryGrid, but this doesn' support SQL Server, yet)