Sybase Advantage New AutoInc after SQL Insert

Question

Anyone knows how to retrieve a new AutoInc that gets written after an ODBC INSERT? Is there a variable I have access to just like SQL Server? Right now, I'm using :

SELECT MAX(myautoincfield) AS mylastkey FROM anytable 

in order to retrieve my new key.

Answer 1

The scalar function LastAutoinc can retrieve it efficiently:

select LastAutoinc(statement) as mylastkey from system.iota;