Archives of the TeradataForum

Message Posted: Fri, 31 Aug 2012 @ 20:56:38 GMT

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

Hi Manish,

I first took a dump of Database A - named it FRI. I am now trying to use the below script and copy the database A to database B using the THUR_1 dump.

     LOGON  10.24.15.207/DBC,"m1cr0sup3rus3r!";
     COPY DATA TABLES(database_B) (FROM (database_A))
     FILE=FRI,
     RELEASE LOCK;
     LOGOFF;

I am running the above script using a bat file , however getting the below error.

     Failure ARC0202:FILE was not expected.
     08/31/2012 15:22:50  LOGGED OFF   3 SESSIONS
     08/31/2012 15:22:50  ARCMAIN TERMINATED WITH SEVERITY 12

What could cause the error??

Thanks

Roopalini

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