Re: Numerical Data Size

Hi Julia,

The numerical definition can be read as follows;

I want to be able to load a number that is upto 4 digits in length, 2 of which may be after the decimal point.

There is no way, except with the use of a CHECK constraint to specify that the number should be less than 100.

Hope this helps,
Andrew

Julia Cristina Varela de Montoya wrote:

> I ran a sql loader today. I insert a flat file with numerical data that
> was as such: 99.99, including the decimal. It never exceed 2,2 in every
> case. I defined the table column as DECIMAL(2,2). I got an error on the
> load, and could only load it when I make the column DECIMAL(4,2) Can
> someone tell me why I need DECIMAL(4,2) for xx.yy? Thank you very much.
Received on Wed Apr 28 1999 - 20:25:58 CDT