Hello, I have a linked server to an iSeries server. I created a new view in the db2 database. When I try execute a new linked server query, it reports invalid object name. I have tried all of the 'refresh' options on the linked server. How do I get SQL to recognize the newly created view? Thank you
And... (further), I need the regular syntax because I intend to use the view in a merge statement, which I do not believe will work in the OPENQUERY format. I am able to query views owned by the exact same user, which is the user in the linked server security context. I also just dropped and recreated the linked server, thinking for sure that would force a refresh, with no luck.