17 Jan 2006
ARCHIVE is a separate program from BTEQ on Teradata. it is called ARCMAIN.Here are the directions that come wit the Teradata Demo CD about archiving the database. I updated it to match what you specified above.Create a file with notepad called b-sample.txt. Its contents should be:LOGON tdpid/user,password;ARCHIVE DATA TABLES (geref) ALL, RELEASE LOCK,INDEXES,OUTPUT ROW COUNT, FILE = geref.dat; LOGOFF;note FILE = can only be 8 chars with no path Create another file names b-sample.bat. Its contents should be:arcmain sessions=2 < b-sample.txt > b-sample.logdel *.rlgpause
Hi,i try to archive a database with all tables ans constraints but i've a problem. Could you help me please ...On BTEQ, i'm connect with dbc/sysdba.--> Logon successfully completed..archive data tables (geref) ALL, release lock, file= geref.dat *** Error: Unrecognized command ARCHIVEwith geref, my database.an idea ???