Is it possible.... Decimal(5,2) or (7,3)

sreenigacc · New User Joined: 16 Oct 2007 Posts: 15 Location: bangalore

Hi All,

Could you please let me know that, Is it possible to declare the datatype(DECIMAL) in DB2 as shown below

salary decimal(5,2) or (6,2)

i) is it possible to declare ?
ii) if yes, what's the meaning of the above declaration ?

Thanks in advance
Sreenivasulu G

guptae · Posted: Mon Oct 29, 2007 1:17 pm

Hi There,

Yeap u can declare

vijikesavan · Posted: Tue Oct 30, 2007 11:16 pm

Are you asking if a same column can be defined like decimal(5,2) or (6,2) ????
pls be more clear.
Thanks,
Viji

sreenigacc · New User Joined: 16 Oct 2007 Posts: 15 Location: bangalore

hi vijikesavan,

yes, if we declare that for a same column what does it mean?

thanks
sreeni

Craq Giegerich · Posted: Tue Apr 15, 2008 8:26 pm

You can define it either way but NOT both!