Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 21 May 2004 @ 19:48:55 GMT


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


Subj:   Macros
 
From:   Hassinger, Bill

I am looking at a script to update objects used by Teradata Manager. Currently we have a macro dbcmngr.ResetAmpUsage defined as :

     REPLACE MACRO DBCMNGR.ResetAMPUsage
             ( ResetAccount  ( char ( 30) ),
                     ResetUser  ( char ( 30) ))
     as (
             update dbc.acctg set cpu=0,io=0
     where accountname=:ResetAccount  and
             username=:ResetUser;
     );

The update script has the following statement identified as "Required for SM" (System Maintenance utility?):

     REPLACE MACRO DBCMNGR.ResetAMPUsage
     as (;));

Can someone explain what the semi-colon in the AS statement means?

THANKS



     
  <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