Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 01 Aug 2000 @ 15:22:40 GMT


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


Subj:   Re: True rounding algorithm
 
From:   Claudia Cuello

It's also occur in V2R3 (00.01.36) and V2R3 (00.02.12)

     BTEQ -- Enter your DBC/SQL request or BTEQ command:
     sel * from dbc.dbcinfotbl;

     sel * from dbc.dbcinfotbl;

      *** Query completed. 2 rows found. 2 columns returned.
      *** Total elapsed time was 1 second.

     InfoKey                        InfoData
     ------------------------------ --------------------------------------------
     RELEASE                        V2R.03.00.01.36
     VERSION                        03.00.01.59

      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     sel 99.5 (decimal(3,0))
        ,99.50 (decimal(3,0))
        ,99.500 (decimal(3,0))
        ,99.5000 (decimal(3,0))
        ,99.50000 (decimal(3,0))
     ;

     sel 99.5 (decimal(3,0))
        ,99.50 (decimal(3,0))
        ,99.500 (decimal(3,0))
        ,99.5000 (decimal(3,0))
        ,99.50000 (decimal(3,0))
     ;

      *** Query completed. One row found. 5 columns returned.
      *** Total elapsed time was 1 second.

      99.5  99.50  99.500  99.5000  99.50000
     -----  -----  ------  -------  --------
      100.   100.     99.     100.      100.

      BTEQ -- Enter your DBC/SQL request or BTEQ command:

     sel * from dbc.dbcinfotbl;

     sel * from dbc.dbcinfotbl;

      *** Query completed. 2 rows found. 2 columns returned.
      *** Total elapsed time was 1 second.

     InfoKey                        InfoData
     ------------------------------ --------------------------------------------
     VERSION                        03.00.02.31
     RELEASE                        V2R.03.00.02.12

      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     sel 99.5 (decimal(3,0))
        ,99.50 (decimal(3,0))
        ,99.500 (decimal(3,0))
        ,99.5000 (decimal(3,0))
        ,99.50000 (decimal(3,0))
     ;

     sel 99.5 (decimal(3,0))
        ,99.50 (decimal(3,0))
        ,99.500 (decimal(3,0))
        ,99.5000 (decimal(3,0))
        ,99.50000 (decimal(3,0))
     ;

      *** Query completed. One row found. 5 columns returned.
      *** Total elapsed time was 1 second.

      99.5  99.50  99.500  99.5000  99.50000
     -----  -----  ------  -------  --------
      100.   100.     99.     100.      100.

      BTEQ -- Enter your DBC/SQL request or BTEQ command:


     
  <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: 27 Dec 2016