Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 23 Jan 2008 @ 13:19:24 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020