title: On IBM i, how to run a stored procedure via DB2 command of QShell?
body: <p>How would you run a stored procedure via DB2 command of QShell, as I need a simple way to unit test a change to a stored procedure?</p>
  
  <p>On IBM i </p>
  
  <p>Started qshell with </p>
  
  <p>QSH</p>
  
  <p>Entered these db2 commands in various formats without success</p>
  
  <pre><code>db2 call libraryname.stroredprocedurename('param1value' 'param2value' ?)
  
  db2 call libraryname.stroredprocedurename ('param1value' 'param2value' ?)
  
  db2 call libraryname.stroredprocedurename (param1value  param2value ?)
  </code></pre>
  
  <p><a href="https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.routines.doc/doc/t0007055.html" rel="nofollow noreferrer">Only reference source I could find</a></p>
  
  <p>Have tried using CLP to call stored proceduresbut there are no CLP examples
  <a href="https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_71/sqlp/rbafyexamplecall.htm" rel="nofollow noreferrer">here</a></p>