title: Creating a SQL insert statement with both parameters and select statement
body: <p>I am trying to come up with a DB2 SQL statement that does the following, but I am not sure
  if this is allowed. </p>
  
  <p>I know that it's possible to <code>insert into tableA ( ... ) Values (?,?,?,...)</code><br>
  and then assign values to those parameters <code>?</code>.  </p>
  
  <p>Is it possible to pre-defined the value of one of the parameter?   </p>
  
  <p>For example, one of the column that I am trying to insert is the <code>ID column</code> and I would like to make it something like <code>select max(id) + 1 from tableA</code>.</p>
  
  <p>This is what I am trying to get to - is this syntax possible in <code>db2</code>?</p>
  
  <pre><code>insert into tableA (ID, Text1, Text2) VALUES (select max(id)+1 from tableA, ?, ?)
  </code></pre>
  
  <p>Anyways - any help would be appreciated!</p>
  
  <p>thanks!! </p>