title: create db2 non clustered index
body: <p>Can you please tell me how to create a nonclustered index in DB2 ?I am not able to find any commands for that. I want to create one index on three columns. I tried:</p>
  
  <pre><code>CREATE INDEX IX_ACCOUNTNOTES_DATE_TYPE 
  ON CPMTD.ACCOUNT_NS (ACCOUNT_ID,CREATED_DATE,NOTE_TYPE);"
  </code></pre>
  
  <p>Its giving me error as:</p>
  
  <pre><code>   DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;TED_DATE,NOTE_TYPE );END-OF-STATEMENT,       DRIVER=3.50.152   
  
      Message: An unexpected token "" was found following "".  Expected tokens may include:  "TED_DATE,NOTE_TYPE )".. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.50.152 
  </code></pre>
  
  <p>ALso, create nonclustered index command is not working for db2.</p>
  
  <p>any help will be greatly appreciated.</p>
  
  <p>Thank you.</p>