title: SQL INSERT ERROR -117: number of values is not equal to number of columns
body: <p>I am new to SQL and I am trying to experiment with different SQL queries. This time I have difficulties with INSERT INTO statement. Here is the table I defined:</p>
  
  <pre><code>CREATE TABLE EMPLOYEES 
  (
      EMP_ID CHAR(9) NOT NULL, 
      F_NAME VARCHAR(15) NOT NULL,
      L_NAME VARCHAR(15) NOT NULL,
      SSN CHAR(9),
      B_DATE DATE,
      SEX CHAR,
      ADDRESS VARCHAR(30),
      JOB_ID CHAR(9),
      SALARY DECIMAL(10,2),
      MANAGER_ID CHAR(9),
      DEP_ID CHAR(9) NOT NULL,
      PRIMARY KEY (EMP_ID)
  );
  </code></pre>
  
  <p>It is empty. Now I am trying to populate table with some data and got stuck with -117 error. I am sure, I am doing some stupid mistake here, but despite all my experience in different areas, I don't see there. Here is INSERT INTO statement I am trying to execute:</p>
  
  <pre><code>INSERT INTO EMPLOYEES (EMP_ID, F_NAME, L_NAME, SSN, SEX, ADDRESS, JOB_ID, SALARY, MANAGER_ID, DEP_ID)
  VALUES ('E1001', 'John', 'Thomas', '123456', 'M', '5631 Rice, OakPark,IL', '100', 100000, '30001', '2'),
         ('E1002', 'Alice', 'James', '123457', 'F', '980 Berry ln, Elgin,IL', '200', 80000, '30002', '5'),
         ('E1003', 'Steve', 'Wells', '123458', 'M', '291 Springs, Gary,IL', '300', 50000, '30002', '5'),
         ('E1004', 'Santosh', 'Kumar', '123459', 'M', '511 Aurora Av, Aurora,IL', '400', 60000, '30004', '5'),
         ('E1005', 'Ahmed', 'Hussain', '123410', 'M', '216 Oak Tree, Geneva,IL', '500', 70000, '30001', '2'),
         ('E1006', 'Nancy', 'Allen', '123411', 'F', '111 Green Pl, Elgin,IL', '600', 90000, '30001', '2'),
         ('E1007', 'Mary', 'Thomas', '123412', 'F', '100 Rose Pl, Gary,IL', '650', 65000, '30003', '7'),
         ('E1008', 'Bharath', 'Gupta', '123413', 'M', '145 Berry Ln, Naperville,IL', '660', 65000, '30003', '7'),
         ('E1009', 'Andrea', 'Jones', '123414', 'F', '120 Fall Creek, Gary,IL', '234', 70000, '30003', '7'),
         ('E1010', 'Ann', 'Jacob', '123415', 'F', '111 Britany Springs,Elgin,IL', '220', 70000, '30004', '5');
  </code></pre>
  
  <p>and DB2 server returns the following error:</p>
  
  <blockquote>
    <p>SQL0117N  The number of values assigned is not the same as the number of specified or implied columns or variables.  SQLSTATE=42802 SQLCODE=-117</p>
  </blockquote>
  
  <p>Two questions here:</p>
  
  <ol>
  <li><p>Why do I see this -117 error here? I counted endless times - number of columns and arguments are the same. Everything should be fine, but it is not.</p></li>
  <li><p>How to set <code>B_DATE</code> column? I decided to leave <code>B_DATE</code> for later, but I still need to deal with it somehow. From information I found on Internet, DATE is stored as binary column. I have no idea how to encode it and ask DB2 server to store it properly. I just need some idea, I should be able to understand details myself.</p></li>
  </ol>
  
  <p>Don't know if this is important, but I am working with DB2 using Python 3.x from Jupiter Notebook. Data I read from example CSV file. I can populate table from DB2 console using built-in CSV reader, but not from Jupiter Notebook.</p>
  
  <p>Thanks</p>