 |
 |
Archives of the TeradataForum
Message Posted: Tue, 01 Aug 2000 @ 15:22:40 GMT
| 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:
| |
