Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 27 Feb 2003 @ 21:30:26 GMT

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

Subj:   Re: WINDDI, QUERYMAN and BTEQ generate different output for the same query
From:   Geoffrey Rommel

  When I run the following query thru Queryman and WinDDI i get results as expected, but when I run them in BTEQ, it gives a different answer. WHY?  

The results are the same, of course; it's just that the display of the results is different. The underlying columns in DBC.DatabaseSpace are all defined as FLOAT, so your outputs are floating-point as well. Queryman and WinDDI ignore format clauses; instead, they have options that tell how many decimal places to display for floating-point numbers (default=0). BTEQ by default displays all places.

So the real question is: why isn't BTEQ displaying your numbers with the formats that you specified? I believe this is because the formats are attached to the terms within the case expression, not to the entire expression. If you apply the format to the entire expression, as shown below, you will get the requested formatting from BTEQ.

SELECT DatabaseName,
(CASE WHEN (Sum(PeakPerm)/NULLIFZERO(Sum(MaxPerm))*100) IS NULL
ELSE (Sum(PeakPerm)/NULLIFZERO(Sum(MaxPerm))*100)
END) (format '999,999,999,999') (TITLE 'Peak Perm//usage (%)') ...

[you probably want 'ZZZ,ZZZ,ZZZ,ZZ9']

  <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