2623201 - Error 247: Arithmetic overflow during explicit conversion of DECIMAL value ... to NUMERIC. - SAP ASE

• Received the following error:

Msg 247, Level 16, State 1:
Server 'myASE', Line 1:
Arithmetic overflow during explicit conversion of DECIMAL value '4440585983' to a NUMERIC field .

• When changing a column's datatype as:

alter table  mytable modify mycolumn  DT_IDENTITY_9 null

• The table has several columns defined as:

 Column_name    Type             Length Prec Scale Nulls Not_compressed Default_name Rule_name Access_Rule_name Computed_Column_object Identity
 -------------- ---------------- ------ ---- ----- ----- -------------- ------------ --------- ---------------- ---------------------- ----------
 col1           DT_DECIMAL4_0         3    4     0     0              0 NULL         NULL      NULL             NULL                            0
 mycolumn       DT_DECIMAL10_0        6   10     0     0              0 NULL         NULL      NULL             NULL                            0
 col3           DT_DECIMAL2_0         2    2     0     0              0 NULL         NULL      NULL             NULL                            0
 col4           DT_IDENTITY_6         4    6     0     0              0 NULL         NULL      NULL             NULL                            0
 col5           DT_INDIC_SEQNR_3      3    3     0     0              0 NULL         NULL      NULL             NULL                            0
 col6           DT_IDENTITY_6         4    6     0     0              0 NULL         NULL      NULL             NULL                            0
 col7           DT_SEQNR              4 NULL  NULL     0              0 NULL         NULL      NULL             NULL                            0
 col8           DT_IDENTITY_9         5    9     0     1              0 NULL         NULL      NULL             NULL                            0
 …

SAP Adaptive Server Enterprise (ASE)

range, digit, precision , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem