Archives of the TeradataForum

Message Posted: Wed, 14 Jun 2006 @ 18:20:17 GMT

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

Hi Vireta,

Have you tried some thing like

     LOGON 172.16.134.3/dbc ,dbc;
     ARCHIVE DATA TABLES
       (Database1.Account_Table)
      ,(Database1.Customer_Table)
      ,(Database1.Transaction_Table)
     ,RELEASE LOCK
     ,INDEXES
     ,ABORT
     ,FILE=ArchiveFileName;
     LOGOFF;

In this example you will have you send your output to a file called ArchiveFileName

Fachtna O'Donovan
Software Engineer
AIB Bank
Ireland

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