Our company is using iSeries for DB2/AS400 and we're hoping someone can help us with this simple question. Would there be a way to return the identity value from an insert statement without using two lines of SQL? We're currently being forced to use inline SQL in C# to perform an insert. Basically, we need the DB2 equivalent of Oracle's "RETURNING".
INSERT INTO AwesomeTable (column1, column2, etc.)
VALUES (value1, value2, etc.)
December 17, 2013 9:01 PM
December 18, 2013 6:27 AM