Archives of the TeradataForum
Message Posted: Tue, 03 Aug 2005 @ 02:39:44 GMT
| Subj: | | Re: Writing UDF for Numeric Datatypes |
| |
| From: | | Geoffrey Rommel |
| | It should be able to support any numeric with variable precisions. How will I will be able to do that ? | |
Defining your input parameters as FLOAT should allow them to be any numeric type, but check the UDF Programming manual to be sure.
| | Not really getting the storing part in the structure DECIMAL8. | |
DECIMAL8 (used for "decimal" fields of 10 or more digits) is two long ints. The low-order word contains the lower 32 bits of the value; the
high-order word contains the upper 31 bits and the sign.
| 
