Archives of the TeradataForum

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

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

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