ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Data Generation NEXTVAL does not publish from 1 in Datamaker


Article ID: 15979


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


Using the following function in any numeric column:


Although set to 1, it always publishes into the database with a 2 to start.


Does 'nextval' actually have a starting value of 1?



Test Data Manager (TDM)- Datamaker 4.2 / TDM Portal


When creating a new nextval starting with 1, in the process of resolving the expression to check its validity, it gets incremented to 2.


Additional Information