Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

The Return Generated Keys feature can be used when inserting data to a table that has auto increment key columns. The auto incremented key value of the record is mapped to the result output mappings of the data service.

For example, the sample query below is used to insert values to a table called 'wes_teams' which has an auto increment column.

Image Added

Once the user selects Return Generated Keys option, an auto increment key will be added as an output mapping. For example,

Image Added