All Forums Database
hesham 1 post Joined 12/13
19 May 2014
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.
 
 
 

jim 3 posts Joined 05/09
20 Oct 2014

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=

You must sign in to leave a comment.