Generating Sequential and Unique Values

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Data Sources and Targets > Databases and MapForce > Introduction to Database Mappings >

Generating Sequential and Unique Values

When inserting data or updating a database, sometimes you might need to create "on-the-fly" sequential or unique values for those database fields which do not have any input from the mapped source. For such cases, use the following built-in MapForce library functions:

 

auto-number (available in the "core | generator functions" library). This function is generally used to generate primary key values for a numeric field.
create-guid (available in the "lang | generator functions" library). This function creates a globally-unique identifier (as a hex-encoded string) for the specific field.

 

Note that values for database fields can also be written using database-generated values. This option is available on the Database Table actions dialog box (see Database Table Actions Settings) and is particularly useful when generating primary keys.


© 2019 Altova GmbH