title: Select from IBM DB2 using Openquery() and member
body: <p>I want to fetch some data from an IBM DB2 server using SQL Server 2008. </p>
  
  <p>For this I have tried to use:</p>
  
  <pre><code>SELECT * From Openquery(LINKED_SRV,'Select * from dta.Filename')
  </code></pre>
  
  <p>which gives me data, albeit rather old data. </p>
  
  <p>I have since gathered that the updated data is in another Member on the server, and that the default member is the outdated one I tried to import data from. </p>
  
  <p>I am told the current Member is <code>PROD2017</code>. I have read some <code>IBM DB2</code> documentation where a <code>Library.Filename(Member)</code> convention is used, but using:</p>
  
  <pre><code> SELECT * From Openquery(LINKED_SRV,'Select * from dta.Filename(PROD2017)')
  </code></pre>
  
  <p>but this gives me an error that <code>(</code> is not supported. </p>
  
  <p>Of several attempts which has failed I have also tried to use:</p>
  
  <pre><code> SELECT * From Openquery(LINKED_SRV,'Select * from dta.Filename"(PROD2017)"')
  </code></pre>
  
  <p>which actually gives a result set, but it is the same result set as the original one omitting the membership, so I'd reckon there is some issue with the Query either way. </p>
  
  <p>How can I find data using openquery() from an <code>IBM DB2</code> server using Sql server, when the <code>DB2</code> server uses membership? </p>