Using ARCMAIN

Database
Fan

Using ARCMAIN

.logon 127.0.0.1/dbc,dbc;
    
ARCHIVE DATA TABLES
     (RETAIL) ALL,
     RELEASE LOCK,
     FILE=ARCHIVE;
.logoff;

Hi,

I want to archive teradata database table. I am using above script.

after executing the script. I got following error.

Failure 3706 Syntax error: expected somthing between the beginning of the request and the word 'ARCHIVE'.

I am unable to find the error.

Can Any one help me.

Thanks in Advance.

Tags (3)
1 REPLY
jim
Teradata Employee

Re: Using ARCMAIN

Don't use the word "ARCHIVE" as the file name. Arcmain is probably getting it confused with the word ARCHIVE in "ARCHIVE DATA TABLES". Try a different FILE=