I was talking with Jonathan Gennick about the INS/UPD/DEL RETURNING stuff, and he recommended looking into the way DB2
handlessimilar functionality. After looking into it a bit, it's more inline with what Tom's suggestion was regarding a
queryfrom the operation rather than returning the values in the manner currently required. <br /><br />Here's DB2's
syntax...does anyone have any familiarity with it?<br /><br />Simply put, it's sort-of like:<br /><br />SELECT * FROM
(FINAL| NEW | OLD) TABLE (INSERT | UPDATE | DELETE)<br /><br clear="all" />I'd like to hear from anyone that's used it
tosee if it really is better... logically it seems nicer, but I've never used it. <br /><br />-- <br />Jonah H. Harris,
DatabaseInternals Architect<br />EnterpriseDB Corporation<br />732.331.1324<br />