Archives of the TeradataForum

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

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

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>>