FIXEDDEC returns a FIXED DEC value with precision and scale derived from the source unless explicitly specified as parameters to the function.
|
If both p and q are omitted, the precision of the result is determined from the source according to this table:
| source | result |
|---|---|
| FIXED BIN(p,q) |
FIXED DEC(r,s) where r = min(N,1+CEIL(p/3.32)) and s=CEIL(ABS(q/3.32))*SIGN(q) |
| FIXED DEC(p,q) | FIXED DEC(p,q) |
| FLOAT BIN(p) |
FIXED DEC(r,0) where r = min(N,CEIL(p/3.32) |
| FLOAT DEC(p) | FIXED DEC(p,0) |
| BIT |
FIXED DEC(r,0) where where r = min(N,1+CEIL(M/3.32)) |
| CHAR, GRAPHIC or WIDECHAR | FIXED DEC(N,0) |