Archives of the TeradataForum
Message Posted: Mon, 02 Apr 2001 @ 20:23:40 GMT
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?.
Thanks in advance
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|