title: Why am I getting this SQL/DB error?
body: <p>I am trying to run a simple SQL statement with DB2 and am having a few problems.
  I would like to have a single script in a txt/db2 file and have the engine process all of the commands</p>
  
  <p>Here is the script:</p>
  
  <pre><code>CONNECT TO MYDB
  
  CREATE TABLE PERSONS(
       PID SMALLINT NOT NULL,
       NAME VARCHAR(20) NOT NULL
  )
  
  TERMINATE
  </code></pre>
  
  <p>When I run a db2 -f /pathtofile I get:</p>
  
  <pre><code>SQL0104N  An unexpected token "(" was found following "CREATE TABLE PERSONS".  
  Expected tokens may include:  "END-OF-STATEMENT".  SQLSTATE=42601
  </code></pre>
  
  <p>What am I doing wrong? Is there something wrong with my script?
  Also, why is it working without ";" terminators at the end of my statements?</p>
  
  <p>Thank you,</p>