Archives of the TeradataForum

Message Posted: Wed, 14 Jun 2006 @ 10:56:17 GMT

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

This is the archival code which works for a single table.

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

When I want to archive more than 1 tables from the database I typed the following code:

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

But the above code doesn't work. I get this error *** Failure ARC0202: , was not expected.

Regards,

Vireta Godinho

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