In this blog post, let’s learn about the error message “1510 Identity column col-name can be of the following data types only: LARGEINT, unsigned INTEGER and unsigned SMALLINT.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1510 Identity column col-name can be of the following data types only: LARGEINT, unsigned INTEGER and unsigned SMALLINT.
Reason for the Error
An unsupported data type is specified for IDENTITY column.
Solution
Modify the IDENTITY column data type to LARGEINT, unsigned INTEGER, or unsigned SMALLINT, and resubmit the statement
