Archives of the TeradataForum

Message Posted: Mon, 03 Nov 2003 @ 15:21:20 GMT

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

Hi Friends,

Is there a way I can write an arcmain script which backs up a particular database but exclude some tables from it.

I have tried these 2 variants:

------------------------------------------------

Logon $logon;
archive data tables (dwtables) all,
exclude (dwtables.waybill_data),
release lock,
file=x;
logoff;

------------------------------------------------

Logon $logon;
archive data tables (dwtables) all,
exclude (waybill_data),
release lock,
file=x;
logoff;

------------------------------------------------

The first one fails with a syntax error and the second one does not exclude the waybill_data table.

Any help would be appreciated.

Worried,

Rohit

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