title: Getting parameters error when using ibm_db_dbi sql query in python
body: <p>I'm trying to use the results from one query to use in the where clause of another and cannot get it to work.  at the moment i'm getting an error....</p>
  <blockquote>
  <p>ProgrammingError: ibm_db_dbi::ProgrammingError: Exception('Statement Execute Failed: [IBM][CLI Driver] CLI0100E  Wrong number of parameters. SQLSTATE=07001 SQLCODE=-99999')</p>
  </blockquote>
  <p>My code below (eventually, 'result' will just be a variable assigned to the results from another query, but for now i'm just trying to get it to work with a static variable.  Thanks in advance!</p>
  <pre><code>import ibm_db_dbi as db
  result = ['c80fS4Pn1', '9f*hzNT21']
  conn = db.connect('DRIVER=DB2 zOS;'
                       'DATABASE=xxxx;'
                       'HOSTNAME=xxxx.com;'  
                       'PORT=xxx;'
                       'PROTOCOL=xxxx;'
                       'UID=id;'
                       'PWD=passord;', '', '')
  cur = conn.cursor()
  sql = &quot;SELECT * FROM SCHEMA.TABLE WHERE PRIM_KEY IN (?)&quot;
  cur.execute(sql, (result)) 
  conn.close()
  </code></pre>