Archives of the TeradataForum

Message Posted: Fri, 22 Jul 2011 @ 14:09:13 GMT

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

HI,

If you are working on PPI table, below archive and copy will work successfully.

For ARCHIVE:

     ARCHIVE DATA TABLES
     (db_old.tablename) ( PARTITIONS WHERE (! x IN(x_106) !)), RELEASE LOCK, FILE=ARCHIVE;
     LOGOFF;

For Copy:

     COPY DATA TABLES
     ( db_new.tablename_XXX  ) (from ( db_old.tablename )), RELEASE LOCK, FILE=ARCHIVE;
     LOGOFF;

If it into same tablename and there no other tables in archive job not required to give 'from' in COPY syntax.

     COPY DATA TABLES
     ( db_new.tablename ),
     RELEASE LOCK,
     FILE=ARCHIVE;
     LOGOFF;

Thanks,

Nagaraju Muriki

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