Archives of the TeradataForum

Message Posted: Tue, 18 Jan 2011 @ 09:40:07 GMT


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

Subj:		Re: Values input to a Macro

From:		David Clough

Thanks to Marek Frydryszak for pointing out :

Default length for char type is 1, so in_wk is treated as char(1) and 'N/A' is cut to 'N', '01' to '0' etc.

This now works

     EXEC TNTCALDAYSDIFF_M01(
     IN_DATE = CURRENT_DATE -7
     ,IN_TNT_WK = 'N/A',IN_TNT_MTH  = 'N/A',IN_TNT_QTR  = 'N/A',IN_TNT_YR = 'N/A'
     ,IN_DAYS_DIFF = 'N/A',IN_WKS_DIFF  = '1',IN_MTHS_DIFF  = 'N/A'
     ,IN_QTRS_DIFF = 'N/A',IN_YRS_DIFF  = 'N/A') ;

To me, however, unless I'm missing many of the opportunities offered by Macros, they actually seem a bit limited to me. If anyone wants to put me straight on this point, I'd be glad to bow to a greater knowledge but, as things stand, I'm not that impressed.

Regards

David Clough
Database Developer
Database Design Group