i am using oledb driver for db2 NT 7.2 to create linked server the connection is fine but whenver i select on some tables i got this error The OLE DB provider "DB2OLEDB" for linked server "xxxxxx" supplied inconsistent metadata for a column. even if i did not include the column in the select.
SSIS same it not to have this problem because always validate metadata set to false, but i need linked server try to add use early metadata=true to the end of connection string but no luck.
i do not want to use openquery because i have complicated join and other things .
thank you