Hi All,
I have created a linked server on SQL Server 2005 to access data from DB2.
I am able to execute it with the command "SELECT * FROM OPENQUERY(DB2SRV,
'SELECT * FROM dbname.dbowner.tblname') however, not able to execute the
same
thing with "SELECT * FROM DB2SRV.dbname.dbowner.tblname". Seems very
strange.
Any help in this regard will be appreciated.
Thanks in advance for any reply.
Ashwin
