hi all,
I have an issue after i convert string to decimal..
this is the derivation for the column which is of decimal 5 as length and precision as 1, "if condtn then (stringtodecimal(column1[4,2])) else null" .
i dont understand how i can get a value 0490.0, for the input 000490.
It has a space as the first character in the output. how can it store a character (space) in a decimal field?
pls help me in solving this..
string to Decimal conversion
Moderators: chulett, rschirm, roy
Re: string to Decimal conversion
Hi alone,
The first character is reserved for the sign... For example -0490.0.
This is not a problem with ODBC connection nether OCI plug in. If you store this decimal in a sequential file, use a CHAR/VARCHAR type.
Matthieu.
The first character is reserved for the sign... For example -0490.0.
This is not a problem with ODBC connection nether OCI plug in. If you store this decimal in a sequential file, use a CHAR/VARCHAR type.
Matthieu.