Home Page for the TeradataForum
 

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



     
  <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: 15 Jun 2023