Maximum Value of the IDENTITY Column

The maximum value that you can insert into an IDENTITY column is 10 precision - 1. If you do not specify a precision for the IDENTITY column, SAP ASE uses the default precision for numeric columns (18 digits).

Once an IDENTITY column reaches its maximum value, insert statements return an error that aborts the current transaction. When this happens, use one of the methods discussed below to remedy the problem.