Hi!

In dynamic SQL I'm inserting a row to a table with an IDENTITY column.
How can I retrieve the generated identity value?

The statement "VALUES IDENTITY_VAL_LOCAL()" returns the following error
when I try to PREPARE it:
SQL0142N  The SQL statement is not supported.  SQLSTATE=42612
SQLSTATE 42612: The statement string is an SQL statement that is not
acceptable in the context in which it is presented.
Any ideas?

Thanks.

WhoReallyCares