title: RPG embedded SQL set option commit=*CS
body: <p>In free form RPG using embedded SQL, I specified this for my SQL options:</p>
  
  <pre><code>exec sql
   set option commit=*CS,
   datfmt=*iso,
   closqlcsr=*endmod;
  </code></pre>
  
  <p>If I specify <code>commit=*CS</code>, do I need to specify <code>WITH CS</code> on my SQL select statement or is that assumed since I specified it in the set option?</p>
  
  <p>If I specify <code>commit=*none</code>, and then specify <code>WITH CS</code> on my SQL select statement will the <code>WITH CS</code> take effect since on my set option commit I said <code>*none</code>?</p>