HPE NonStop SQL/MX Error – 1620 Scale should be zero for sequence generator.

In this blog post, let’s learn about the error message “1620 Scale should be zero for sequence generator.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1620 Scale should be zero for sequence generator.

Reason for the Error

You specified a non-zero value for scale in the CREATE SEQUENCE statement.

Solution

Resubmit the statement with scale set to zero