Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023