Archives of the TeradataForum
Message Posted: Wed, 23 Jan 2008 @ 13:19:24 GMT
| Subj: || || Re: Loading a numeric with format like ZZZ.ZZZ.ZZZ,ZZ |
| From: || || Victor Sokovin |
| ||I know that is possible change some parameter on the system to assign the , as the decimal separator and the . as the group separator, but
I would like avoid it.|| |
The other way would be to change the radix and group separator settings for the FL session but for some mysterious reason this has never been
possible in Teradata SET SESSION command. You can change the character set of the session, which is a big change, but you cannot change the
peanuts like group and radix separators. Very strange.
I think the only feasible way to proceed for you is to request a change in the extraction job.