SAP Knowledge Base Article - Preview

3736985 - Getting error "Identity field 'a' must be a numeric with a scale of 0." when create an identity field on a table

Symptom

Getting error  "Identity field 'a' must be a numeric with a scale of 0."  when create an identity field on a table, even the numeric(x,0) has been specified in DDL.


Read more...

Environment

Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.1

Keywords

identity, numeric(10,0),  numeric with a scale of 0 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.