title: The multi-part identifier could not be bound using a linked server with ODBC connection to a DB2
body: <p>when I run this simple query </p>
  
  <pre><code>select [B00BF4CR].[IWSE4S8].[SCTRN].[STCOMP], 
  [EPAK].[B00BF4CR].[IWSE4S8].[SCTRN].[STDATE],
  [EPAK].[B00BF4CR].[IWSE4S8].[SCTRN].[STUNM],
  [EPAK].[B00BF4CR].[IWSE4S8].[SCTRN].[STQTY] 
  FROM [EPAK].[B00BF4CR].[IWSE4S8].[SCTRN] 
  WHERE [EPAK].[B00BF4CR].[IWSE4S8].[SCTRN].[STCOMP]='51' 
  AND [EPAK].[B00BF4CR].[IWSE4S8].[SCTRN].[STDATE] = 20140211 
  AND [EPAK].[B00BF4CR].[IWSE4S8].[SCTRN].[STVOID] = 'N' 
  ORDER BY [EPAK].[B00BF4CR].[IWSE4S8].[SCTRN].[STTCKT]
  </code></pre>
  
  <p>in my sql I got the below errors</p>
  
  <pre><code>Msg 4104, Level 16, State 1, Line 3
  The multi-part identifier "EPAK.B00BF4CR.IWSE4S8.SCTRN.STCOMP" could not be bound.
  Msg 4104, Level 16, State 1, Line 4
  The multi-part identifier "EPAK.B00BF4CR.IWSE4S8.SCTRN.STDATE" could not be bound.
  Msg 4104, Level 16, State 1, Line 4
  The multi-part identifier "EPAK.B00BF4CR.IWSE4S8.SCTRN.STVOID" could not be bound.
  Msg 4104, Level 16, State 1, Line 1
  The multi-part identifier "B00BF4CR.IWSE4S8.SCTRN.STCOMP" could not be bound.
  Msg 4104, Level 16, State 1, Line 1
  The multi-part identifier "EPAK.B00BF4CR.IWSE4S8.SCTRN.STDATE" could not be bound.
  Msg 4104, Level 16, State 1, Line 1
  The multi-part identifier "EPAK.B00BF4CR.IWSE4S8.SCTRN.STUNM" could not be bound.
  Msg 4104, Level 16, State 1, Line 2
  The multi-part identifier "EPAK.B00BF4CR.IWSE4S8.SCTRN.STQTY" could not be bound.
  Msg 4104, Level 16, State 1, Line 5
  The multi-part identifier "EPAK.B00BF4CR.IWSE4S8.SCTRN.STTCKT" could not be bound.
  </code></pre>
  
  <p>when I do double clic on the 1st one it highlight this section</p>
  
  <pre><code>FROM [EPAK].[B00BF4CR].[IWSE4S8].[SCTRN] 
  WHERE [EPAK].[B00BF4CR].[IWSE4S8].[SCTRN].[STCOMP]='51' AND
  </code></pre>
  
  <p>the 2nd and the 3rd ones </p>
  
  <pre><code>[EPAK].[B00BF4CR].[IWSE4S8].[SCTRN].[STDATE] = 20140211 
  AND [EPAK].[B00BF4CR].[IWSE4S8].[SCTRN].[STVOID] = 'N' ORDER BY
  </code></pre>
  
  <p>4, 5 and 6</p>
  
  <pre><code>select [B00BF4CR].[IWSE4S8].[SCTRN].[STCOMP], 
  [EPAK].[B00BF4CR].[IWSE4S8].[SCTRN].[STDATE],
  [EPAK].[B00BF4CR].[IWSE4S8].[SCTRN].[STUNM],
  </code></pre>
  
  <p>7</p>
  
  <pre><code>[EPAK].[B00BF4CR].[IWSE4S8].[SCTRN].[STQTY] 
  </code></pre>
  
  <p>8</p>
  
  <pre><code>[EPAK].[B00BF4CR].[IWSE4S8].[SCTRN].[STTCKT]
  </code></pre>