|
|
Archives of the TeradataForum
Message Posted: Mon, 18 Jul 2011 @ 11:49:39 GMT
Subj: | | Re: ARCMAIN COPY + PARTITIONS WHERE |
|
From: | | Mankala, Mahesh |
try this i think it will work
for Archive:
.logon TDPID/username,passwd;
ARCHIVE DATA TABLES
(Students.orders_PPI_M)
(PARTITIONS WHERE (! o_orderdate = DATE '2000-01-25' !)),
RELEASE LOCK,
FILE=ARCHIVE;
.logoff;
For Copy:
.logon TDPID/username,passwd;
COPY DATA TABLES
(Students.orders_rst ) (from(Students.orders_PPI_M )),
RELEASE LOCK,
FILE=ARCHIVE;
.LOGOFF;
| |