NUMBER data types
Posted: Thu Jan 25, 2007 12:28 pm
We generally use DataStage to move data from sources to Oracle.
In Oracle, it's my understanding that there are different NUMBER data types:
NUMBER(6) would allow six digits max. I think that may mean 6 total including decimals, so you could have 4 before the decimal and 2 after, but not more than 6 total.
NUMBER(11,2) would allow 11, but 2 are reserved for the decimal.
NUMBER is unlimited in any direction.
So I figured we should just go with NUMBER since it will accomdate anything.
However, I'm not sure what the best way to use these data types in DataStage is.
Do you recommend using Decimal? What about the length and scale values?
In Oracle, it's my understanding that there are different NUMBER data types:
NUMBER(6) would allow six digits max. I think that may mean 6 total including decimals, so you could have 4 before the decimal and 2 after, but not more than 6 total.
NUMBER(11,2) would allow 11, but 2 are reserved for the decimal.
NUMBER is unlimited in any direction.
So I figured we should just go with NUMBER since it will accomdate anything.
However, I'm not sure what the best way to use these data types in DataStage is.
Do you recommend using Decimal? What about the length and scale values?