You can looking for the host variable %ROWID that has the last id of the row afected by a INSERT/DELETE/UPDATE.
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_esql#GSQL_esql_pcROWID
Another way is the function LAST_IDENTITY
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_last_identity
- Log in to post comments
.png)
.png)
.png)
.png)
.png)
.png)
.png)