![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Tue, 25 Jun 2013 @ 13:53:36 GMT
Subj: | | ARCMAIN : the clause "partitions where" |
|
From: | | Aitsakel Rochdi |
Hi Forum,
I have a question concerning ARCMAIN tool. I need to archive a set of partitions of a table. This table is partitioned by a timestamp(0)
field.
The following expression is valid ? :
---------------------------------------------------------------------
ARCHIVE DATA TABLES
("TABLE1")
(PARTITIONS WHERE (!(CAST DAT_HEUR_ALLC AS DATE AT LOCAL)
BETWEEN DATE '2013-07-01' AND DATE '2013-07-31' !) ) , RELEASE LOCK, FILE=ARCHIVE;
---------------------------------------------------------------------
Thanks,
Rochdi AITSAKEL
| |