Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 May 2003 @ 10:01:35 GMT


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


Subj:   ASP & Teradata Macros
 
From:   Shah Irani

Hi,

I'm running some ASP which uses some Teradata macros to pull data off a warehouse. We're using V2R4.1 along with ODBC v03.01.00 (which was all recently upgraded).

The problem we're encountering is that the ASP does not display decimal places for any of the data...all the ASP is doing is using a loop with 'results.movefirst and results.movenext'. It's not that it's rounding, it is actually chopping off the decimal places. What is really bizarre is that the macro works fine in Queryman 6, just not in the ASP. I've tried running the macro as just SQL within the ASP but no joy. Whatever I do, the figures (they are defined as DECIMAL (9,2)) still are coming through as characters.

Can anyone possibly help?


Thanks in advance,

Shah



     
  <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