title: Querying a DB2 table using the "DISTINCT" keyword from MSAccess
body: <p>I've got a rather simple query to a linked DB2 table.</p>
  
  <pre><code>SELECT GC_TBSELC.*
  FROM GC_TBSELC
  WHERE SELC_EFF_DATE &gt; #1/1/2017#;
  </code></pre>
  
  <p>Works fine, returns results.  However, when I add the "DISTINCT" keyword, I get an error:</p>
  
  <blockquote>
    <p>ODBC -- CALL FAILED</p>
    
    <p>[[IBM][CLI Driver][DB2] SQL0904N  Unsuccessful execution caused by an
    unavailable resource.  Reason code: "00C90305", type of resource:
    "00000100", and resource name: "DSNDB07".  SQLSTATE=57011</p>
  </blockquote>
  
  <p>Any idea on why the "DISTINCT" keyword would cause this, and if there's a way around it to get distinct records from the table?</p>