Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Thu, 15 Apr 1999 @ 13:51:22 GMT





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




Subj:   Re: Numeric functions in Teradata
 
From:   John Hall



Teradata has nothing like the SERIAL function. As Eric already mentioned, when somebody wants to create a system-assigned number, it has to be done by an external process before the data is loaded. I've toyed with the idea of using one of the HASH functions to generate a relatively unique number from data contained within a row, but there's always the possibility of a synonym.

Out of curiosity, what does the NUMBER(*) function do? My background is Teradata and so the function is new to me.


John





     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008