Archives of the TeradataForum

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

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

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

I think Teradata expects to find between brackets either a table name or a database name, not a comma separated list of objects.

Try something like this instead:

     ARCHIVE DATA TABLEs (DBname) EXCLUDE TABLES (DBname.TableName3,
     DBname.TableName4) ,
     RELEASE LOCK,
     FILE=check;

Regards,

Victor

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