title: How to Truncate table in DB2? Error: Not a valid Command Line Processor command
body: <p>Running following statement in DB2 CLP (Command Window)</p>
  
  <blockquote>
    <p>db2 "truncate table MYSCHEMA.TABLEA immediate"</p>
  </blockquote>
  
  <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:
  SQL0969N  There is no message text corresponding to SQL error "-20356" in the
  message file on this workstation.  The error was returned from module
  "SQLNQBE2" with original tokens "MYSCHEMA.TABLEA".
  </code></pre>
  
  <p>Can some please tell me what I'm doing wrong or what I'm missing? I'm trying to simply truncate from a single table and I'm getting the following error message. Not sure what I'm doing wrong. I've tried it with/without quotes, with/without schema, with/without immediate. I've also tried in Command Editor (remove db2 and quotes) and still not working.  I'm using:
  DB2/AIX64 9.7.9
  Also, I have delete privilege as I am able to delete records but I want to truncate.</p>
  
  <p>Thanks in advance!</p>