question

tstrole avatar image
tstrole asked

Refresh meta data in iSeries linked server

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
linked server
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Does the credentials used within the linked server have the appropriate permissions to the new view?
0 Likes 0 ·
Yes, it is the super user.
0 Likes 0 ·
I also know I have the proper format, since I can query another view fine. I am then plugging in the new view name.
0 Likes 0 ·
tstrole avatar image
tstrole answered
And... one last time (further), curiously I just executed the select statement (with the red line indicating 'Invalid object name', and the query executed. Strange. I'll mark this answered.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

tstrole avatar image
tstrole answered
Further, the OPENQUERY syntax works, but just not the direct select.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

tstrole avatar image
tstrole answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.