title: iSeries DB2 - Is there any way to select the identity value from an insert statement?
body: <p>I know we're rare, us poor folk that are using iSeries for DB2/AS400, but I'm hoping someone can answer this simple question.  Is there any way to return the identity value from an insert statement without using two lines of SQL?  I'm being forced to use inline SQL in C# to perform an insert, and then I need to use the identity generated for the insert for something later on.  Simply put, I need the iSeries DB2 equivalent of Oracle's "RETURNING."  I.e.,</p>
  
  <pre><code>INSERT INTO AwesomeTable (column1, column2, etc.)
      VALUES (value1, value2, etc.)
      RETURNING something;
  </code></pre>
  
  <p>Anyone?  Thanks in advance.</p>
  
  <p><strong>EDIT: Unless someone knows of a way I can execute two lines of SQL in one IBM.Data.DB2.iSeries.iDB2Command (not a stored proc), I would like to do this all in one line of SQL</strong> </p>