I created an table alias in DB2 and created a linked DB2 server in SQL Server 2008 with the IBMDASQL provider. Now I need to query the alias from SQL Server, but I receive the following error message:
Msg 7357, Level 16, State 2, Line 3
Cannot process the object "S650a370.PROBIS03.NAW_ALIAS". The OLE DB provider "IBMDASQL" for linked server "DB2SQL" indicates that either the object has no columns or the current user does not have permissions on that object.
However, the object has multiple columns and I have Owner permissions on that object.
I tried to create the linked server with the IBMDA400 and IBMDARLA providers without any success. I also tried to query some other tables and that works fine, but when i try to query an alias i get an error message. Unfortunately I need to use the alias, because the underlying table contains multiple members and I can't query a table member directly with an SQL command.
Any ideas? Thanks in advance.