Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 02 Apr 2001 @ 20:23:40 GMT


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


Subj:   Derived Table in Macro
 
From:   Thopay Sudarsan

Hi All,

     Create Macro  Refresh_Bank as
     (
     update  FinanceBANK from
          (sel bank_nbr,bank_name
          from MarketingBank
          where capt_dt='20010228' )mytemp(bnr,bnm)
     set bank_name=bnm
     where bank_nbr=bnr
     and capt_dt='20010228'
     ;
     );

The above example macro creation fails with the error - Code = 3610. Internal error: Please do not resubmit the last request. Output directed to Answer set window.

Seems like any Macro creation that uses Derived Tables fail with the above error. Am i thinkg right.?. Are derived tables NOT allowed in Macros?.

Any Insight?


Thanks in advance

Sudarsan Thopay



     
  <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