Archives of the TeradataForum

Message Posted: Wed, 14 Jun 2006 @ 14:04:14 GMT

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

You're nearly there - it's just your syntax at fault.

You need parantheses around each table being archived.

So: -

     LOGON 172.16.134.3/dbc ,dbc;
     ARCHIVE DATA TABLEs (DBname.TableName1), (DBname.TableName2) ,
     RELEASE LOCK,
     FILE=check;
     LOGOFF;

If you're archiving the entire database (DBname), having just the DBname in brackets will cover all tables.

cheers,

Mark

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