.logon 127.0.0.1/dbc,dbc; ARCHIVE DATA TABLES (RETAIL) ALL, RELEASE LOCK, FILE=ARCHIVE;.logoff;
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.
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=