Regarding data declaration

[Former Member]

I am writing a report based on the number of customers.

For ex: if the number of customers are greater than 50, peform this, if the number of customers are greater than 100, perform that etc.

My question is - Should I declare 'number of customers' as integer or numeric ? What difference does it make?

Thanks in advance for your input,

Krishen

[RichHeilman]

No difference really since you are not storing the value in a table. Just use integar.

The value is the same, but with a numeric, it is stored with leading zeros, with integar, it is just the value.

Regards,

Rich Heilman

[Former Member]

Thanks Rich!

If I store the value in a table, should I use numeric ? If so, why?

Regards,

Krishen

Message was edited by: Krishen

[RichHeilman]

It really depends on how you plan to use this value. If it is strictly a counter type of field, either type would be ok.

Regards,

Rich Heilman

[anversha_s]

hi kishen,

since its customer u declare it integer.

rgds

anver

mark all hlpful answers

[Former Member]

no difference you can use either of the way ..

[Former Member]

hi,

Better you declare it as integer.

If you declare it as numeric, you need to know what will be the upper limit to the no. of customers. Ofcourse, integer also has a limit.

data: v_cnt(4) type n.

it can not hold greater than 9999. So, better declare as integer instead of numeric as you dont know the no of customers.

Regards,

Sailaja.