Data Generation NEXTVAL does not publish from 1 in Datamaker

Document ID : KB000015979
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Using the following function in any numeric column:

@nextval(td1,1)@

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

 

Question:

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

 

Environment:
Test Data Manager (TDM)- Datamaker 4.2 / TDM Portal
Answer:

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:

https://docops.ca.com/ca-test-data-manager/4-2/en/reference/data-generation-functions-and-parameters