Skip to Main Content
InterSystems Ideas
We love hearing from our users. Tell us what you want to see next and upvote ideas from the community.
* Bugs and troubleshooting should as usual go through InterSystems support.
Status Planned
Categories InterSystems IRIS
Created by Stefan Cronje
Created on Nov 10, 2023

SQL Return ID

Add functionality to SQL to use RETURN on insert statements. To return the value of whichever field is specified after the insert.

Can be useful when using SQL to insert records and you need the ID immediately without having to select it.

  • ADMIN RESPONSE
    Aug 20, 2025

    Thank you for submitting the idea. The status has been changed to "Planned or In Progress".

    This is not a commitment; plans are subject to change. Stay tuned!