Archives of the TeradataForum

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

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

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