|
|
Archives of the TeradataForum
Message Posted: Fri, 14 Dec 2007 @ 19:52:55 GMT
Subj: | | Re: Representation of Partitioned Priomary Indexes in DBC |
|
From: | | Curley, David |
Thanks, Kamin.
One thing I noticed: DBC.INDEXCONSTRAINTS.ConstraintText contains more or less the actual partitioning text, so when you parse it, be sure to
look for all forms a date might take. For example, you might find
CHECK ((RANGE_N(data_dt BETWEEN 1050101 AND 1071231 EACH INTERVAL '1'
MONTH , NO RANGE OR UNKNOWN)) BETWEEN 1 and 65535)
CHECK ((RANGE_N(data_dt BETWEEN '2007/04/01' AND '2008/12/31' EACH
INTERVAL '1' MONTH , NO RANGE OR UNKNOWN)) BETWEEN 1 and 65535)
So maybe you'd want to look for '%2007%' or '%107%'.
Dave
| |