<div>
&lt;My linked server is reading DB2 tables but I don't see the linked server object at all when trying to import any.&gt;<br />
<br />
what sql server version\edition do you use?<br />
what sql server permissions do you have?
</div>


<My linked server is reading DB2 tables but I don't see the linked server object at all when trying to import any.>

what sql server version\edition do you use?
what sql server permissions do you have?

<div>
try to <br />
exec sp_tables_ex yourlinkedservername <br />
<br />
sp_tables_ex <br />
Returns table information about the tables from the specified linked server.<br />
---<br />
<br />
2 things can be -- used DB2 driver and DB2 user permissions
</div>


try to
exec sp_tables_ex yourlinkedservername

sp_tables_ex
Returns table information about the tables from the specified linked server.
---

2 things can be -- used DB2 driver and DB2 user permissions

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I am trying to import tables from the linked server to my local DB using Ms SQL server 2008 R2. My linked server is reading DB2 tables but I don't see the linked server object at all when trying to import any.<br />
<br />
Any advice?<br />
<br />
Regards,
</div>
</div>


Dear Experts,

I am trying to import tables from the linked server to my local DB using Ms SQL server 2008 R2. My linked server is reading DB2 tables but I don't see the linked server object at all when trying to import any.

Any advice?

Regards,

Linked Server

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.