Archives of the TeradataForum

Message Posted: Mon, 03 Nov 2003 @ 17:46:13 GMT

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

Hi,

Try something like

Logon $logon;
ARCHIVE DATA TABLES (DatabaseName)
   (EXCLUDE TABLES
      (  DatabaseName.TableName1
        ,DatabaseName.TableName2
        ,DatabaseName.TableName3
      )
   )
,RELEASE LOCK
,INDEXES
,ABORT
,FILE=ARCHIVE;
LOGOFF;

BTW this will only work if you are using V2R4 or higher

Fachtna

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