In this blog post, let’s learn about the error message “3411 Expressions are not allowed as IDENTITY column values. Specify default or supply a numeric value.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
3411 Expressions are not allowed as IDENTITY column values. Specify default or supply a numeric value.
Reason for the Error
An expression was specified as an input for IDENTITY column value instead of numeric value or DEFAULT.
Solution
Specify a valid numeric value or DEFAULT, and resubmit the statement