title: db2 create index but hit SQLSTATE=42703
body: <p>I have a table created successfully.</p>
  
  <p>1 of the column name is <code>code</code> and another 1 is "deleted".</p>
  
  <p>Thus, I plan to use this 2 field to create its index. I am doing something like follow:</p>
  
  <pre><code>CREATE INDEX SADM.IDX_SC_IDX1 on SADM.SC ("code" ASC, "DELETED") ALLOW REVERSE SCANS;
  </code></pre>
  
  <p>This is working fine in my local. However, I hit this error in UAT:</p>
  
  <pre><code>DB21034E  The command was processed as an SQL statement because it was not a
  valid Command Line Processor command.  During SQL processing it returned:
  SQL0205N  Column, attribute, or period "code" is not defined in
  "SADM.SC".  SQLSTATE=42703
  </code></pre>
  
  <p>I double check the table and confirm the "code" column or "deleted" is exist and same with my local.</p>
  
  <p>I believe something wrong is inside but I cant find the root cause.</p>
  
  <p>Kindly advise.</p>