Having played around with this a bit more, I declared both a numeric(5,0)
and a decimal(5,0). Both fields accept numbers up to 9 digits long
(inclusive). This seems to go against documentation:

"Numeric(5,0) declares that a column of this type always holds exactly 5
digits..." (page 64. DataDef.pdf)

Could someone please shed some light on this for me?


Regards,

Andrew

> Reading the doc (page 64 of the DataDef.pdf), it says that numeric always
> stores as many digits as the maximum size of the field.
>
> My question is:
>
> Will Numeric(5,0) store 1 as 00001 or just 1? Or will an insert of 1 into
> that field fail as it doesnt contain enough digits?
>
>
> Cheers,
>
> Andrew
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>